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

Executing SQL Output Files After the Second Pause

Upgrades: All upgrades.

Environments: Development (midtier-centric) environment.

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

The schema and data migration output files created by the Siebel Upgrade Wizard before the second pause message are generated into the default output directory or into the output directory that you specified in Table 22. You execute the output files in two stages:

• Stage 1

  In stage 1 you execute a sub-set of the output files created by the Siebel Upgrade Wizard before the second pause message. Then you deploy stored procedures and user-defined functions as described in Deploying Stored Procedures and User-Defined Functions.

• Stage 2

  After you deploy the stored procedures and user-defined functions, you execute the remainder of the output files created by the Siebel Upgrade Wizard before the second pause message.

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

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

CAUTION:  If any of the scripts run and are not successful, data is lost and cannot be recovered. At this point, the only way to recover is to back out the changes or start over. If there are no copies of the objects, the changes cannot be backed out. Therefore, it is recommended that you make copies of your objects before running the scripts.