1. Database Upgrade Guide for DB2 for z/OS
  2. Applying the Additive Changes in One Job

Applying the Additive Changes in One Job

You can apply all the additive schema upgrade changes to the target database using the JCL in the data set DSNHLQ.SIEBEL.INSTALL.JCL(ADDVSCHT) provided you also applied all of the additive changes to the staging database using the JCL in the DSNHLQ.SIEBEL.INSTALL.JCL(ADDVSCHS) data set.

Caution: If you applied only a subset of the additive schema upgrade changes to the staging database, you must not apply the additive schema upgrade changes to the target database using the JCL in the data set DSNHLQ.SIEBEL.INSTALL.JCL(ADDVSCHS). If you do, you will corrupt the target database.

To apply all additive changes to the target production database

  1. Navigate to the ISPF Primary Option Menu, and select option 2: Edit.

  2. Specify DSNHLQ.SIEBEL.INSTALL.JCL(ADDVSCHT) as the name of the data set member you want to edit on the Edit Entry Panel.

  3. Submit the job in the ADDVSCHT member.

    All of the additive schema changes are automatically submitted and applied to the target database.

    Note: You must choose to either apply all of the additive changes in one job, or apply them all individually. If you apply any of the additive changes to the target database individually, as described in Applying Additive Changes Individually, you cannot use the DSNHLQ.SIEBEL.INSTALL.JCL(ADDVSCHT) member to apply additive changes; attempting to do will cause an error in your upgrade.

  4. To ensure performance is not adversely affected when additive changes are applied in one job using the ADDVSCHT member, all of the indexes are created using the DEFINE YES, DEFER YES syntax. After applying the additive changes, you can rebuild the indexes for each index created by the ADDVSCHT member by submitting the JCL in the DSNHLQ.SIEBEL.INSTALL.JCL(SUBADDIX) data set.

    You can submit the index rebuild jobs all together, or individually. To submit the rebuild index jobs in one step:

    1. Navigate to the ISPF Primary Option Menu, and select option 3.4.

    2. On the Data Set List Utility (DSLIST) panel, type EXEC on the line next to the @SUBADDIX member. Press Enter.

      All of the rebuild index jobs are submitted.

    To submit each index rebuild job individually:

    1. Edit the DSNHLQ.SIEBEL.INSTALL.JCL(SUBADDIX) member by typing e before the member name. Press Enter.

    2. Select the job you want to run, type submit on the command line, and press Enter.

      The rebuild index job is submitted.