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

Executing SQL Output Files After the Third Pause

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 before the third pause message are generated into the default output directory or into the output directory that you specified in Table 22.

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

UNIX: The default DDL output directory is DBSRVR_ROOT/db2390/dboutput/upgrade.

To execute the SQL output files after the third pause

• Execute the SQL output files in the following order from the DB2 command window. See Executing SQL Files After the First Pause for execution procedures.
  • indexes.sql

    This file creates Siebel indexes.

  • gen_primary1.sql
  • gen_primary2.sql
  • gen_primary3.sql
  • gen_primary4.sql

    The gen_primary*.sql files update data in the tables.

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