Siebel Database Upgrade Guide for DB2 for z/OS > Creating the Siebel Staging Database >

Removing Interface Tables and Triggers

Once you have build the staging database and prepared the upgrade environment on the z/OS host, the final task to complete before you generate the upgrade files is to remove triggers and EIM/Interface tables from the staging database. The following procedure describes this task.

To remove EIM/Interface tables and triggers from the staging database

1. On the Staging Database Environment Setup Menu, select option 6: Generate EIM/Interface Table/Tablespace Drops, and press Enter.
2. Submit the JCL in the data set DSNHLQ.SIEBEL.pregen.jcl (PREGEN1). This job generates the EIM, Interface table, and table space DROP statements.
3. Verify that the job ran successfully as described in Verifying JCL Upgrade Jobs.
4. After submitting the job, enter cancel on the command line or press PF3 to save changes.
5. On the Staging Database Environment Setup Menu, select option 7. Generate Trigger Drops List of Tbl w/ CLOB columns, and press Enter.
6. Submit the JCL in the data set DSNHLQ.SIEBEL.pregen.jcl (PREGEN2). A list of trigger drops and tables with CLOB columns is generated.
7. Verify that the job ran successfully.
8. After submitting the job, enter cancel on the command line or press PF3 to save changes.
9. On the Staging Database Environment Setup Menu, select option 8 Drop Interface Tables, and press Enter.
10. Submit the JCL in the data set DSNHLQ.SIEBEL.install.jcl (INFDRPJS) to drop EIM and Interface tables from the staging database.
11. Verify that the job ran successfully as described in Verifying JCL Upgrade Jobs.
12. After submitting the job, enter cancel on the command line or press PF3 to save changes.

This completes the process of creating a staging database. You can now generate the upgrade files.