Preparing eMessage system tables for the partition

For each partition that you create for eMessage, you must create, populate and configure the eMessage system tables that are used by the partition in the Campaign schema.

Complete the following actions to prepare the eMessage system tables for a partition:

Create the eMessage system tables.

In your database client, run the SQL scripts for creating system tables against the Campaign database.

Populate the tables that you created.

Use the database client to run the scripts for populating tables against the Campaign database. For more information about the SQL scripts, see the reference table for script names and locations at Creating and populating the eMessage system tables manually.

Set the following configuration properties in the eMessage configuration for the partition, specifying the user name and platform data source that you configured for the partition's Campaign system user:

eMessage > partitions > partition [n] < dataSources > systemTables > asmUserForDBCredentials

eMessage > partitions > partition [n] < dataSources > systemTables > amDataSourceForDBCredentials

eMessage accesses the partition's system tables through a system user configured in Marketing Platform. A Marketing Platform data source added to the system user provides the required access credentials. Because the eMessage system tables exist in the Campaign schema for the partition, you can use the system user that you created to access the Campaign schema to access the partition's eMessage system tables.

Update the following properties in the partition's configuration properties:

eMessage > partitions > partition [n] < dataSources > systemTables > type

eMessage > partitions > partition [n] < dataSources > systemTables > schemaName

eMessage > partitions > partition [n] < dataSources > systemTables > jdbcBatchSize

eMessage > partitions > partition [n] < dataSources > systemTables > jdbcClassName

eMessage > partitions > partition [n] < dataSources > systemTables > jdbcURI

See the Marketing Platform online help for each property to learn more about setting the configuration properties. For additional information about these configuration properties and configuring eMessage, see the IBM® eMessage Startup and Administrator's Guide.

Creating and populating the eMessage system tables manually