Synchronizing the Schema

Upgrades: All upgrades.

Environments: Development environment only.

This topic is part of an upgrade process. See Performing 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. Use the following command to display the Siebel In-Place Upgrade Main Menu:

   EXEC 'DSNHLQ.SIEBEL.EXEC' 
   

   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 with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.

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 with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.

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

    Upgphys processing is now completed.