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.
Procedure
Complete the following steps to create a database or database schema for Campaign system tables:
- 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.
- Print the Campaign 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 IBM eMessage system
tables are created in the Campaign schema
during the installation. However, eMessage is
not enabled.