Review SQL upgrade script and modify, if necessary

If your Interact runtime environment includes customizations to the runtime system tables that modified the default Data Definition Language (DDL) included with Interact, you must modify the default SQL upgrade script for your database to match your customizations.

Common customizations include changes to support multiple audience levels or using views of tables. You may want to review the data dictionaries for the new versions of IBM® products to confirm column sizes map correctly and that foreign key constraints from additional products do not conflict.

The aci_runtab_upgrd and the aci_usrtab_upgrd are the SQL upgrade scripts that most likely require revisions.

You must complete these changes before running the Interact upgrade tool.

1.	Locate the upgrade script for your database type. The scripts are installed in the /ddl/Upgrades or /ddl/Upgrades/Unicode directory under your Interact installation after you run the IBM® EMM installer in upgrade mode.

2.	Ensure that your database schema matches the DDL included with Interact. If your database schema does not match the DDL in the upgrade script, edit the script for your database type to match your environment.

Example modifications to the SQL upgrade script