Siebel Database Upgrade Guide for DB2 UDB for z/OS > Generating the Siebel Upgrade Files > Preparing and Executing the Non-Additive Schema and JCL Files on the z/OS Host >

Applying the Non-Additive Schema Changes


Perform the following procedure to apply the non-additive schema changes to the staging database.

If you are performing a development database upgrade, or if you are performing a production database upgrade but chose not to apply any additive changes in advance, all the Siebel 8.0 schema upgrade changes are now applied to the staging database.

To apply non-additive schema changes

  1. On the Staging Database Non-Additive Schema Menu, select option 4: Apply Non-Additive Changes, and press Enter.
  2. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(SCHEMAS).
  3. Verify that the job ran successfully. Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 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.
Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.