Siebel Database Upgrade Guide for DB2 for z/OS > Performing Postupgrade Tasks on the Target Database >
Synchronizing the Schema
Upgrades: All upgrades. Environments: Development environment only. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. After completing the development environment target database upgrade, you must perform the following procedure to synchronize database tables and indexes. To synchronize the schema
- Use the following command to display the Siebel In-Place Upgrade Main Menu:
EXEC 'DSNHLQ.SIEBEL.EXEC'
The panel ID is SBLUPG8P.
- Select option 4: Post-Upgrade, and press Enter.
The Target Database Post-Upgrade Menu appears. The panel ID is SBLPSTP.
- Select option 0: Apply/Run Table Synchronization, and press Enter.
You are placed in edit mode for the data set &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCT) .
- Run the job using the JCL in the data set.
This job submits the SYNCTAB (synchronize table) job which executes a file containing the DDL for the tables.
- Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
- After submitting the job, enter
cancel on the command line or press PF3 to save changes.
- On the Target Database Post-Upgrade Menu, select option 1: Apply/Run Index Synchronization, and press Enter.
You are placed in edit mode for the data set &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCX) .
- Run the job using the JCL in the data set.
This job submits the SYNCIDX (synchronize index) job which executes a file containing the DDL for the indexes.
- Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
- Press PF3 to return to the Upgrade In-Place Main Menu.
Upgphys processing is now completed.
|