Step: Create and populate the Interact system tables
Use your database client to run the Interact SQL scripts against the appropriate database or schema to create and populate the Interact runtime environment; design environment; learning; user profile; and contact and response tracking data sources.
Design environment tables
Before you can enable the Interact design environment in Campaign, you must add some tables to your Campaign system table database.
The following tables list the SQL scripts you can use to manually create and populate the design environment tables.
The SQL scripts are in the <Interact_HOME>/interactDT/ddl directory in your Interact design environment.
If your Campaign system tables are configured for Unicode, use the appropriate script that is in the <Interact_HOME>/interactDT/ddl/unicode directory in your Interact design environment. There are no Unicode equivalent scripts for the aci_populate_systab scripts that are used to populate the design environment tables.
Scripts for creating design time tables
Data source type
Script name
IBM® DB2®
aci_systab_db2.sql
The user table space and system temporary table space where the Campaign system tables exist must each have a page size of 32K or greater.
Microsoft™ SQL Server
aci_systab_sqlsvr.sql
Oracle
aci_systab_ora.sql
Scripts for populating design-time tables
Data source type
Script name
IBM® DB2®
aci_populate_systab_db2.sql
Microsoft™ SQL Server
aci_populate_systab_sqlsvr.sql
Oracle
aci_populate_systab_ora.sql
Runtime environment tables
The following tables list the SQL scripts you can use to create and populate the Interact runtime tables.
The SQL scripts are in the <Interact_HOME>/ddl directory under your Interact installation.
If your Interact runtime tables are configured for Unicode, use the appropriate script that is in the <Interact_HOME>/ddl/Unicode directory to create the runtime tables. There are no Unicode equivalent scripts for the aci_populate_runtab scripts that are used to populate the runtime tables.
You must run these scripts one time for each server group data source.
Scripts for creating runtime environment tables
Data source type
Script name
IBM® DB2®
aci_runtab_db2.sql
The user table space and system temporary table space where the Interact runtime environment tables exist must each have a page size of 32K or greater.
Microsoft™ SQL Server
aci_runtab_sqlsvr.sql
Oracle
aci_runtab_ora.sql
Scripts for populating runtime environment tables
Data source type
Script name
IBM® DB2®
aci_populate_runtab_db2.sql
You must use the following command when you run this script: db2 +c -td@ -vf aci_populate_runtab_db2.sql
Microsoft™ SQL Server
aci_populate_runtab_sqlsvr.sql
Oracle
aci_populate_runtab_ora.sql
Tables for optional features
The following tables list the SQL scripts you can use to create and populate tables for Interact features, including learning, global offers, score override, and contact and response history tracking.
Learning
All of these SQL scripts are in the <Interact_HOME>/ddl directory.
*
The built-in learning module requires a separate data source from the Interact runtime environment tables. If you are using the built-in learning module, you must create a data source to hold all of the learning data. This separate data source can communicate with all server groups, which means you can learn from your different touchpoints at the same time.
If your Interact runtime tables are configured for Unicode, use the appropriate script that is in the <Interact_HOME>/ddl/Unicode directory to create the learning tables.
Learning table scripts
Data source type
Script name
IBM® DB2®
aci_lrntab_db2.sql
Microsoft™ SQL Server
aci_lrntab_sqlsvr.sql
Oracle
aci_lrntab_ora.sql
Contact and response history
The following tables list the SQL scripts you must run against the contact history tables if you are using cross-session response tracking or the advanced learning feature.
All of the SQL scripts are in directories that are found in your Interact installation.
*
Using contact and response history features requires a separate data source from the Interact runtime environment tables. If you are using contact and response history, you must create a data source to reference contact and response data. This separate data source can communicate with all server groups.
If your contact history tables are configured for Unicode, use the appropriate script that are in the Unicode directory under the same location as the standard script to create the learning tables.
Contact history table scripts
Data source type
Script name
IBM® DB2®
<Interact_HOME>/ddl/aci_crhtab_db2.sql
<Interact_HOME>/interactDT/ddl/acifeatures/aci_lrnfeature_db2.sql
Microsoft™ SQL Server
<Interact_HOME>/ddl/aci_crhtab_sqlsvr.sql
<Interact_HOME>/interactDT/ddl/aci_lrnfeature_sqlsvr.sql
Oracle
<Interact_HOME>/ddl/aci_crhtab_ora.sql
<Interact_HOME>/interactDT/ddl/aci_lrnfeature_ora.sql
Copyright IBM Corporation 2013. All Rights Reserved.