Creating and populating the Opportunity Detection system tables

If you have not created and populated the system tables during the installation process, use your database client to run the Opportunity Detection SQL scripts against the appropriate database, or to create and populate the Opportunity Detection runtime environment and design environment.

All SQL scripts exist in the Installation_Home/OpDetection/database/DB2/DesignTime directory in your Opportunity Detection design environment.

Design environment tables

Before you can deploy the Opportunity Detection design environment, you must create tables in the Opportunity Detection system table database.

Run Time environment table

Use the following scripts to create and populate the Run Time environment tables:

opDetectRunTimeSchema.sql

OutcomeTable.sql

StateTable.sql

The opDetectRunTimeSchema.sql script is run by the installer if you choose to upgrade Opportunity Detection automatically. You must run the OutcomeTable.sql and the StateTable.sql manually. However, before running the OutcomeTable.sql and the StateTable.sql scripts, you must make the changes that are described in the following table:

The user table space and system temporary table space where the Opportunity Detection runtime environment tables exist must each have a page size of 32K or greater.

Scripts for creating runtime environment tables

Data source type

Script name and location

Changes required

IBM® DB2®

opDetectRunTimeSchema.sql

Location:

Opportunity_Detection_Install_Home/database_name/RunTime

None.

The script is automatically run by the installer if you choose to upgrade Opportunity Detection automatically.

IBM® DB2®

OutcomeTable.sql