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 >

Executing SQL Output Files After the Second Pause - Stage 2 of 2


This section describes stage 2 of how to execute the output files created by the Siebel Upgrade Wizard before the second pause message. This section assumes that you have deployed stored procedures and user-defined functions as described in Resuming the Siebel Upgrade Wizard After the Second Pause.

To execute the SQL output files after the second 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.

    NOTE:  You may have a subset of these files, because they are produced according to upgrade path and Siebel eBusiness application.

    • preschm.sql
    • preschm_sia.sql
    • prod_configurator.sql
    • prod_configurator_sia.sql
    • upg_iss.sql

      After executing the SQL files successfully and reviewing the log files for unacceptable errors, you may continue with the upgrade.

Upgrade Guide for DB2 UDB for z/OS and OS/390