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
- 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.
- Select option 0: Generate EIM/Interface Table/Tablespace Drops, and press Enter.
- Submit the JCL in the data set
DSNHLQ .SIEBEL. pregen.jcl (PREGEN1) . This job generates the EIM, Interface table, and table space DROP statements.
- 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.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
- On the Staging Database Pre_Gen Maint. Menu, select option 1. Generate: - List of Tables with CLOB columns - Trigger Drops, and press Enter.
- Submit the JCL in the data set
DSNHLQ .SIEBEL. pregen.jcl (PREGEN2) . A list of trigger drops and tables with CLOB columns is generated.
- 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.
- 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.
- Press PF3 to return to the Staging Database Environment Setup Menu.
- Select option 7: Drop Interface Tables, and press Enter.
- Submit the JCL in the data set
DSNHLQ .SIEBEL. install.jcl (PRETIDRP) to drop EIM and Interface tables from the staging database.
- 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.
- 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.
|