For eMessage reports, creating stored procedures staging tables, and indexes

For eMessage, you must run specific scripts after you install or upgrade reporting templates. You must run the SQL scripts against the Campaign database.

The Campaign_reportspack_home\cognos10\emessage-ddl directory is located on the server that hosts the IBM® Cognos® Content Manager, and contains the following database scripts for Oracle, IBM® DB2®, and Microsoft™ SQL Server:

acer_indexes_dbname.sql

acer_scripts_dbname.sql

acer_tables_dbname.sql

1.	Complete the following steps to run the database scripts:

2.	Run the following script against the Campaign database:

acer_indexes_dbname.sql

Make sure that you allow sufficient time for the script to complete. The time that the script requires to complete depends on the amount of data that is currently stored in the eMessage system tables. For more information, see For eMessage reports, limiting scope of delta processing

3.	Run the following script against the Campaign database:

acer_tables_dbname.sql

This script creates the delta processing staging tables in the eMessage system schema.

4.	Run the following script against the Campaign database:

acer_scripts_dbname.sql

This script creates the stored procedures that you must configure after you install Reports for eMessage.

While using the script, if your database is DB2®, change the termination character from ; (semicolon) to ! (exclamation point).