Siebel Database Upgrade Guide for DB2 UDB for z/OS > Upgrading the Target Database >

Applying Additive Upgrade Changes to the Target Database

Upgrades: All upgrades.

Environments: Production test, production.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

NOTE:  For development database upgrades, all schema changes are processed as non-additive so this step does not apply.

Before you can perform the in-place target database upgrade, you must first apply all of the additive schema changes that you previously applied to the production staging database to the production target database. See Applying the Additive Schema Changes to the Production Staging Database for further information.

When applying additive changes, you can either:

• Apply one, or a few of the additive changes to the target database during one or more sessions.
• Apply all of the additive changes as one job, provided that you applied all of the additive changes to the staging database.

Both methods of applying additive changes are described in this section.

Applying Additive Changes Individually

You can apply individual additive changes to the target database using the following procedure.

To apply selected additive changes to the target production database

1. If you are not on the Siebel Upgrade Main Menu, enter the following command:

   TSO SBLUPG80

2. Select option 2: Target Database Processes - Pre-Upgrade, and press Enter.
3. Select option 1: Schedule/Run PENDING Jobs (Target), and press Enter.

   The Target Additive PENDING Job Status Menu is displayed. The panel ID is SBLSADTP.

   This panel lists all the pending additive jobs, that is, all the jobs that were applied as additive jobs to the staging database and which have not been applied to the target database.

4. To apply or view the additive schema changes, enter either J, S, or SUB in the Opt column of the appropriate member, and press Enter:
   • Typing SUB in the Opt column for a member automatically submits the JCL to apply the additive change in the member: DSNHLQ.SIEBEL.ADDTAR.JCL(member)

     To apply all the additive changes together, follow the procedure in Applying the Additive Changes in One Job.

   • Typing J in the Opt column for a member places you in edit mode in the JCL for the member: DSNHLQ.SIEBEL.ADDTAR.JCL(member)
   • Typing S in the Opt column for a member places you in edit mode in the SQL for the member: DSNHLQ.SIEBEL.ADDTAR.SQL(member)

     NOTE:  You can selectively submit additive schema changes according to the amount of time you have available. You must bear in mind, however, that some schema changes may require that other additive database, table space or table changes are applied first. Review the additive changes before submitting them and, in general, submit additive schema changes in database, table space, table hierarchical order.

5. After submitting the JCL to apply the additive change in a member, verify that the job ran successfully:
   1. Review the output in SDSF or another job output facility very carefully. 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.
   2. You can view the Siebel target database job log to check whether an additive job completed successfully or not by navigating to the In-Place Upgrade Main Menu and selecting option 6: Target Database Joblog. See Viewing the Siebel Job Log Status for further information.

      Do not proceed until all the pending additive schema jobs are run successfully.

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 your upgrade.

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 pending additive schema changes are automatically submitted and applied to the target database.