Upgrade Guide for DB2 UDB for z/OS > Upgrading a Development Environment Database from the Midtier >

Synchronizing the Schema

Upgrades: All upgrades.

Environments: Development environment only.

This topic is part of an upgrade process. See How to Perform the Upgrade.

The output files created by the Siebel Upgrade Wizard during the upgphys procedure are generated into the output directory that you specified when you ran the Database Server Configuration utility or into the default output directory (Windows: DBSRVR_ROOT\db2390\dboutput\upgrade; UNIX: DBSRVR_ROOT/db2390/dboutput/upgrade).

To synchronize the schema

1. Execute the SQL output files generated by the Siebel Upgrade Wizard in the following order from the DB2 command window. See Executing SQL Files After the First Pause for execution procedures.

   NOTE:  Do not use the DSNTEP2 utility to execute these files directly on the mainframe.

   • Synctab.sql: Synchronizes tables
   • Syncidx.sql: Synchronizes indexes
   • Tmpdeduptable.sql: Creates the temporary tables used when the dedup*.sql files are executed

     NOTE:  (The tmpdeduptable.sq file is generated and must be executed only if you are upgrading from a pre-v7.7 release of Siebel applications.)

   • Ddlview.sql: Creates the Siebel schema views based on definitions in the dbsrvr/DB2390/ddlview.sql template
2. After executing each SQL file, review the corresponding log file.

   If you are upgrading from a v7.7 release of Siebel applications, upgphys processing is now completed.

3. If you are upgrading from a pre v7.7 release of Siebel applications, after successfully executing the SQL files and reviewing the log files for unacceptable errors, continue the upgrade by selecting Yes on the Siebel Upgrade Wizard screen.