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

1. Enter the following command and press Enter:

   TSO SBLUPG80

   The Siebel In-Place Upgrade 8.0 Main Menu appears. The panel ID is SBLUPG8P.

2. Select option 4: Post-Upgrade, and press Enter.

   The Target Database Post-Upgrade Menu appears. The panel ID is SBLPSTP.

3. Select option 0: Apply/Run Table Synchronization, and press Enter.

   You are placed in edit mode for the dataset &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCT).

4. 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.

5. 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.

6. After submitting the job, enter cancel on the command line or press PF3 to save changes.
7. 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).

8. 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.

9. 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.

10. Press PF3 to return to the Upgrade In-Place Main Menu.

    Upgphys processing is now completed.