Siebel Database Upgrade Guide for DB2 UDB for z/OS > Performing Post-Upgrade 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
- Enter the following command and press Enter:
TSO SBLUPG80
The Siebel In-Place Upgrade 8.0 Main Menu appears. 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 dataset &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCT) .
- Run the job using the JCL in the dataset.
This job submits the SYNCTAB (synchronize table) job which executes a file containing the DDL for the tables.
- Verify that the job ran successfully.
Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 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.
- 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 dataset &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCX) .
- Run the job using the JCL in the dataset.
This job submits the SYNCIDX (synchronize index) job which executes a file containing the DDL for the indexes.
- Verify that the job ran successfully.
Review the output in SDSF or another job output facility. Verify that the RC=0 or RC=4 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.
- Press PF3 to return to the Upgrade In-Place Main Menu.
Upgphys processing is now completed.
|