Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a 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 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 18. 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 as described in Resuming the Siebel Upgrade Wizard After the Second Pause, 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 SIEBEL_ROOT\dbsrvr\db2390\dboutput\upgrade.

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