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.

NOTE:  It is recommended that you drop EIM tables before synchronizing the Siebel logical and physical schema to ensure that the synchronization process does not fail when processing EIM tables.

To synchronize the schema

1. Enter the following command and press Enter:

   TSO SBLUPG81

   The Siebel In-Place Upgrade 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCT).

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

5. Verify that the job ran successfully.

   Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is 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 data set &DSNHLQ.SIEBEL.INSTALL.JCL(SUBSYNCX).

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

9. Verify that the job ran successfully.

   Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is 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.