Creating and populating Campaign system tables manually

By default, the Campaign installer automatically creates and populates system tables. However, if the system tables are not created and populated automatically during the installation, you must populate the system tables manually. Use your database client to run the Campaign SQL scripts against the appropriate database to create and populate the Campaign system tables.

Note: If you plan to enable eMessage, you must also manually create and populate the eMessage system tables if the installer did not do so automatically. For details, see Creating and populating the eMessage system tables manually.

If you selected the Campaign System Table DDL Files option on the Campaign Components page during installation, the IBM® installer installs a collection of SQL scripts that you can use to create and populate the Campaign system tables. The SQL scripts are installed in the ddl directory under your installation of the Campaign server. If your system tables are configured for Unicode, the appropriate scripts are in the ddl/unicode directory under your Campaign installation.

To use the SQL scripts, run your database client to apply the scripts to the database or schema that holds the Campaign system tables. See the documentation for your database software for instructions on running SQL scripts.

The following tables list the SQL scripts that are provided for you to use to create and populate the Campaign system tables manually:

Table 1. Scripts for creating Campaign system tables
Data source type	Script name
IBM DB2®	ac_systab_db2.sql
Microsoft SQL Server	ac_systab_sqlsvr.sql
Oracle	ac_systab_ora.sql

Table 2. Scripts for populating Campaign system tables
Data source type	Script name
IBM DB2	ac_populate_tables_db2.sql
Microsoft SQL Server	ac_populate_tables_sqlsvr.sql
Oracle	ac_populate_tables_ora.sql

You can create tables in the Campaign schema if you want to integrate Distributed Marketing with Campaign.

The following tables list the SQL scripts that are provided for you to use to create the Campaign system tables manually:

Table 3. Scripts for creating Campaign system tables to integrate Distributed Marketing with Campaign
Data source type	Script name
IBM DB2	clb_systab_db2.sql
Microsoft SQL Server	clb_systab_sqlsvr.sql
Oracle	clb_systab_ora.sql

To populate the rows in the system tables that are created by the clb_systab_DB_type.sql script, run the clb_populate_tables.sql script.