Creating and populating reporting tables for Unica Campaign and Unica Deliver

You can use SQL scripts to create and populate reporting tables for Unica Campaign. The reports application uses reporting tables to extract reportable data.

To create and populate reporting tables for Unica Campaign and Unica Deliver, complete the following steps.
  1. Connect to Campaign system database.
  2. Locate the SQL scripts that you generated and saved previously.
  3. Use your database administration tools to run the appropriate script against the appropriate application databases for the report package that you are configuring.
  4. For Campaign with a DB2 database, increase the DB2 heap size to at least 10240. The default heap size is 2048.
  5. Use the following command to increase the heap size:
    db2 update db cfg for
            databasename using stmtheap 10240
    where databasename is the name of the Campaign database.
  6. Use your database administration tools to populate the new tables with the appropriate data from the production system database.
  7. Complete the following substeps. This step is not required for MariaDB datasource.
    1. Navigate to <CAMPAIGN_HOME>/reports/ddl/<DBtype> installation directory.
    2. Locate and execute sp_whatifofferperf.sql.
      Note: For more than one partition, you must run the script for each partition in Campaign database.
    3. For DB2, set DB2_COMPATIBILITY_VECTOR using following command. You must stop and start db2 server post parameter set:
      db2set
              DB2_COMPATIBILITY_VECTOR=ORA

Continue with Setting up data synchronization.

.