For IBM eMessage only: Creating stored procedures, staging tables, and indexes
After you install or upgrade reporting templates, you must run specific SQL scripts before you generate IBM eMessage reports. The SQL scripts create stored procedures and staging tables.
About this task
- acer_indexes_dbname.sql
- acer_tables_dbname.sql
- acer_scripts_dbname.sql
Run the following scripts against the Unica Campaign database in the order listed.
Procedure
-
acer_indexes_dbname.sql
Make sure that you allow sufficient time for the script to complete. The time depends on the volume of data that is stored in the IBM eMessage system tables.
-
acer_tables_dbname.sql
This script creates the delta processing staging tables in the IBM eMessage system schema.
-
acer_scripts_dbname.sql
Important: For DB2® databases, change the termination character from ; (semicolon) to ! (exclamation point).
This script creates the stored procedures that you must configure after you install reports for IBM eMessage.
What to do next
For more information about running and scheduling the stored procedures, see For IBM eMessage only: How to schedule and run stored procedures.