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: 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 as described in Verifying JCL Upgrade Jobs.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
- On the Staging Database Environment Setup Menu, select option 7. Generate Trigger Drops List of Tbl w/ CLOB columns, 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.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
- On the Staging Database Environment Setup Menu, select option 8 Drop Interface Tables, and press Enter.
- Submit the JCL in the data set
DSNHLQ .SIEBEL. install.jcl (INFDRPJS) to drop EIM and Interface tables from the staging database.
- Verify that the job ran successfully as described in Verifying JCL Upgrade Jobs.
- 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.
|