eMessage | partitions | partition[n] | dataSources | systemTables
This category contains configuration properties that define the schema, connection settings, and login credentials for the database that contains the eMessage system tables in your network environment.
type
Description
Type of database that hosts the eMessage system tables.
Default value
No default value defined. You must define this property.
Valid Values
*
*
*
ORACLE10 (also used to indicate Oracle 11 databases)
*
schemaName
Description
Name of the database schema for the eMessage system tables. This is the same as the schema name for the Campaign system tables.
You must include this schema name when referencing system tables in scripts.
Default value
dbo
jdbcBatchSize
Description
The number of execution requests JDBC runs on the database at a time.
Default value
10
Valid Values
An integer greater than 0.
jdbcClassName
Description
JDBC driver for system tables as defined in your Campaign web server.
Default value
No default value defined. You must define this property.
jdbcURI
Description
JDBC connection URI for system tables as defined in your Campaign web server.
Default value
No default value defined. You must define this property.
asmUserForDBCredentials
Description
Use this property to specify an IBM® EMM user that will be allowed to access the eMessage system tables.
Default value
No default value defined. You must define this property.
Valid Values
Any user defined in the Marketing Platform. This should typically be the name of the system user for Campaign
amDataSourceForDBCredentials
Description
Use this property to specify the data source that defines login credentials for the database that contains the eMessage system tables. This can be the same as the data source for the Campaign system tables.
Default value
UA_SYSTEM_TABLES
Valid Values
A Marketing Platform data source associated with the IBM® EMM user you specify in asmUserForDBCredentials
The data source specifies a database user and credentials used to access the eMessage system tables. If the default schema for the database user is not the schema that contains the system tables you must specify the system table schema in the JDBC connection used to access the system tables.
poolAcquireIncrement
Description
When the database connection pool runs out of connections, the number of new connections eMessage creates for the system tables. eMessage creates new connections up to the number specified in poolMaxSize.
Default value
1
Valid Values
An integer greater than 0.
poolIdleTestPeriod
Description
The number of seconds eMessage waits between testing idle connections to the eMessage system tables for activity.
Default value
100
Valid Values
An integer greater than 0.
poolMaxSize
Description
The maximum number of connections eMessage makes to the system tables. A value of zero (0) indicates there is no maximum.
Default value
100
Valid Values
An integer greater than or equal to 0.
poolMinSize
Description
The minimum number of connections eMessage makes to the system tables.
Default value
10
Valid Values
An integer greater than or equal to 0.
poolMaxStatements
Description
The maximum number of statements that eMessage stores in the PrepareStatement cache per connection to the system tables. Setting poolMaxStatements to zero (0) disables statement caching.
Default value
0
Valid Values
An integer equal to or greater than 0.
timeout
Description
The number of seconds eMessage maintains an idle database connection before dropping the connection.
If poolIdleTestPeriod is greater than 0, eMessage tests all idle, pooled, but unchecked-out connections, every timeout number of seconds.
If poolIdleTestPeriod is greater than timeout, the idle connections are dropped.
Default value
100
Valid Values
An integer equal to or greater than 0.