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

Applying the Nonadditive Schema Changes

Perform the following procedure to apply the nonadditive 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 CRM 8.1 schema upgrade changes are now applied to the staging database.

To apply nonadditive 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 data set 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 return code is 0 or4 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.