Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database > Performing the In-Place Target Database Upgrade >

Preparing the Target Database for the Upgrade

Perform the following procedure to drop interface tables, triggers, and stored procedures from the target database to prepare for the upgrade.

To remove interface tables, triggers and stored procedures from the database

1. On the Target Database In-Place Upgrade Menu, select option 0: Drop Interface Tables, and press Enter.

   This option runs the job to remove interface tables from the target database.

2. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(INFDRPJT).

   NOTE:  If your Siebel database contains partitioned EIM tables, before running the job, you must edit the data set SIEBEL.INSTALL.JCL(INFDRPT) to delete the steps that drop table spaces containing partitioned EIM tables. For information, see Dropping Partitioned EIM Tables.

3. Verify that the job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.
4. After submitting the job, enter cancel on the command line or press PF3 to save changes.
5. On the Target Database In-Place Upgrade Menu, select option 1: Drop Triggers, and press Enter.
6. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(TRGDRPJT) to remove triggers from the target database.
7. Verify that the job ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.
8. After submitting the job, enter cancel on the command line or press PF3 to save changes.
9. On the Target Database In-Place Upgrade Menu, select option 2: Drop SPs and Functions, and press Enter.
10. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SPFDRPT).
11. Verify that the job ran successfully with a return code of 0, 4, or 8. For information, see Verifying JCL Upgrade Jobs.
12. After submitting the job, enter cancel on the command line or press PF3 to save changes.