Create views or materialized views for Campaign or eMessage

1.	Locate the SQL scripts that you generated and saved previously. Refer to Scripts SQL por Origem de Dados if necessary.

2.	Use your database administration tools to run the appropriate script against the appropriate application database(s) for the report package you are configuring.

When you run a script that creates materialized views on a DB2® database, your database may return the error "SQL20059W The materialized query table-name may not be used to optimize the processing of queries." However, the materialized view is successfully created.

3.	For Campaign with a DB2® database only, increase the DB2® heap size to 10240 or higher. (The default heap size is 2048.) Use the following command:

db2 update db cfg for databasename using stmtheap 10240

where databasename is the name of the Campaign database.

Increasing the heap size ensures that IBM® Cognos® does not display SQL error messages if a user selects all the campaigns when running a report like the Financial Summary report.

4.	For eMessage only, do the following.

In the ReportsPackCampaign\tools directory under your reports pack installation, locate the uare_lookup_create_DB_type.sql script, where DB_type is the database type appropriate for your installation of Campaign .

Edit the appropriate version of the script to remove the drop table statements and save the script.

Run the appropriate version of the script against your Campaign system tables database.