Bookshelf Home | Contents | Index | PDF     

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).
  3. Verify that the job ran successfully. Review the output in SDSF or another job output facility very carefully. Verify that the return code is 0 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.
  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. Review the output in SDSF or another job output facility. Verify that the return code is 0 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.
  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. Review the output in SDSF or another job output facility. Verify that the return code is 0, 4, or 8 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.
  12. After submitting the job, enter cancel on the command line or press PF3 to save changes.
    
Siebel Database Upgrade Guide for DB2 for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.