SQL scripts for creating system tables

Use the scripts described in the following table to create Marketing Platform system tables manually, when your company policy does not allow you to use the installer to create them automatically.

The scripts are shown in the order in which you must run them.

Scripts for creating system tables

Datasource Type

Script Names

IBM® DB2®

ManagerSchema_DB2.sql

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

ManagerSchema__DB2_CeateFKConstraints.sql

active_portlets.sql

Microsoft™ SQL Server

ManagerSchema_SqlServer.sql

ManagerSchema__SqlServer_CeateFKConstraints.sql

active_portlets.sql

Oracle

ManagerSchema_Oracle.sql

ManagerSchema__Oracle_CeateFKConstraints.sql

active_portlets.sql

If you plan to use the scheduler feature that enables you to configure a flowchart to run at predefined intervals, you must also create the tables that support this feature. To create the scheduler tables, run the appropriate script, as described in the following table.

Scripts for enabling the IBM® EMM Scheduler
Data Source Type	Script Name
IBM® DB2®	quartz_db2.sql
Microsoft™ SQL Server	quartz_sqlServer.sql
Oracle	quartz_oracle.sql

When to use the create system tables scripts

You must use these scripts when you install or upgrade Marketing Platform if you have not allowed the installer to create the system tables automatically, or if you have used ManagerSchema_DropAll.sql to delete all Marketing Platform system tables from your database.