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:

   EXEC ’DSNHLQ.SIEBEL.EXEC’
   

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. Do one of the following:

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

   • To apply or view individual 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)

     • 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 might 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 changes in a member, verify that the job ran successfully with a return code of 0, 4, or 8. For information, see Verifying JCL Upgrade Jobs.

   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.