Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Midtier >

Synchronizing the Schema

Upgrades: All upgrades.

Environments: Development (midtier-centric) environment.

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 procedure Upgrading the Physical Schema are generated into the default output directory or into the output directory that you specified in Table 18.

Windows: The default DDL output directory is SIEBEL_ROOT\dbsrvr\db2390\dboutput\upgrade.

UNIX: The default DDL output directory is $SIEBEL_ROOT/dbsrvr/db2390/dboutput/upgrade.

To synchronize the schema

1. Execute the SQL output files generated by Running the Siebel Upgrade Wizard in the following order from the DB2 command window. See Executing SQL Files After the First Pause for execution procedures.
   • Synctab.sql
   • Syncidx.sql
   • Tmpdeduptable.sql
   • Ddlview.sql
2. After executing each SQL file, review the corresponding log file.

After successfully executing the SQL files and reviewing the log files for unacceptable errors, you may continue the upgrade from the point at which it paused.