Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide for DB2 UDB 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 drop interface tables, triggers and stored procedures

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

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

  2. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(INFDRPJT).
  3. Verify that the job ran successfully. Review the output in SDSF or another job output facility very carefully. Verify that the RC=0 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
  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 dataset DSNHLQ.SIEBEL.INSTALL.JCL(TRGDRPJT) to drop triggers from the target database.
  7. Verify that the job ran successfully. Review the output in SDSF or another job output facility very carefully. Verify that the RC=0 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
  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 dataset DSNHLQ.SIEBEL.INSTALL.JCL(SPFDRPT).
  11. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0, RC=4, or RC=8 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
  12. After submitting the job, enter cancel on the command line or press PF3 to save changes.
    
Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.