Creating and populating the Marketing Platform system tables manually

When you install Marketing Platform, you can select the option where the installer creates the Marketing Platform system tables automatically. Alternatively, you can manually create the system tables.

1.	Complete the following tasks to create and populate the system tables manually:

2.	Run the IBM® installer as described in , but with the following differences in your choices when it launches the Marketing Platform installer.

Select Manual database setup.

Deselect the Run Platform configuration checkbox.

3.	After the installer finishes, create the system tables manually by running the following SQL scripts appropriate for your database type against your Marketing Platform system table database, as described in SQL scripts for creating system tables.

Run the scripts in this order.

ManagerSchema_DBType.sql

If you plan to support multi-byte characters (for example, Chinese, Japanese, or Korean) and your database is DB2®, use the ManagerSchema_DB2_unicode.sql script.

ManagerSchema__DBType_CeateFKConstraints.sql

active_portlets.sql

quartz__DBType.sql

4.	Run the IBM® installer again, making the following selections when it launches the Marketing Platform installer.

Select Manual database setup.

Select the Run Platform configuration checkbox.

This adds default data to the system tables.