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: PREGEN Processes, and press Enter.

   The Staging Database Pre_Gen Maint. Menu is displayed. The panel ID is SBLPREGP. Options on this panel allow you to generate EIM DROP statements, identify tables with CLOB columns, and generate trigger drops.

2. Select option 0: Generate EIM/Interface Table/Tablespace Drops, and press Enter.
3. Submit the JCL in the data set DSNHLQ.SIEBEL.pregen.jcl (PREGEN1). This job generates the EIM, Interface table, and table space DROP statements.
4. Verify that the job ran successfully.

   Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.

5. After submitting the job, enter cancel on the command line or press PF3 to save changes.
6. On the Staging Database Pre_Gen Maint. Menu, select option 1. Generate: - List of Tables with CLOB columns - Trigger Drops, and press Enter.
7. Submit the JCL in the data set DSNHLQ.SIEBEL.pregen.jcl (PREGEN2). A list of trigger drops and tables with CLOB columns is generated.
8. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
9. After submitting the job, enter cancel on the command line or press PF3 to save changes.

   NOTE:  You do not have to run option 2. Generate: Report of Address Duplicate Rowids, or option 3: Update Address Report Generated Log Entry, on the Staging Database Pre_Gen Maint. Menu for upgrades from Siebel CRM 7.5.3 or later to Siebel CRM 8.1.

10. Press PF3 to return to the Staging Database Environment Setup Menu.
11. Select option 7: Drop Interface Tables, and press Enter.
12. Submit the JCL in the data set DSNHLQ.SIEBEL.install.jcl (PRETIDRP) to drop EIM and Interface tables from the staging database.
13. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
14. 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.