Creating database or schema for Campaign system tables

The IBM® Campaign system tables hold application data. The empty database that you set up for the system tables can have any name. To ensure that the system tables will be mapped automatically, the ODBC name for that database must be UA_SYSTEM_TABLES. If you have multiple partitions, create data sources for each partition where you want to enable IBM Campaign.


Complete the following steps to create a database or database schema for Campaign system tables:
  1. Create a system user account for later in the installation process.
    Note: The system user account must have the following rights: CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE.
  2. Print the Contact Optimization installation worksheet. Obtain the information about your database or schema and database account, and then note this information in the checklist. Continue to fill in the checklist as you perform the rest of the steps in this section, so that you can use this information later in the installation process.
    Note: The HCL eMessage system tables are created in the Campaign schema during the installation. However, eMessage is not enabled.