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

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

This section describes stage 1 of how to execute the output files created by the Siebel Upgrade Wizard before the second pause message. Execute the SQL output files in the order shown in the following procedure from the DB2 command window. See Executing SQL Files After the First Pause for execution procedures.

To execute the SQL output files after the second pause

1. Execute the following two files to create and update tables, including temporary tables.
   • schema.sql
   • tmptable.sq
2. Run the following files, as appropriate to your upgrade. These files create and populate temporary tables. Data is migrated to these tables where DML operations are performed. The data is then migrated back to the primary tables and the temporary tables are dropped.

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

   Run the following echannel SQL files if you are upgrading from a Siebel 6.2.1 application.

   • echannel_merge_contact.sql
   • echannel_merge_org_int.sql

     To create and populate the temporary tables used by echannel_merge_contact.sql and echannel_merge_org_int.sql, go to the dbsrvr\db2390 directory and run the following jobs:

     • eChannelAccountDivMatch.sql
     • eChannelEmpContactMatch.sql

       If you are a Financial Services customer, run the following jobs:

     • eChannelAccountDivMatch_fins.sql
     • eChannelEmpContactMatch_fins.sql.
   • echannel_merge_contact_sia.sql
   • echannel_merge_org_int_sia.sql
   • HHMigPop.sql

     NOTE:  Change the HHMigPop.sql file to reflect your site-specific storage details (such as, storage group and schema qualifier). Also, since HHMigPop.sql creates objects that are required for Household_Mig_Fins.sql, make sure you run HHMigPop.sql before running Houshold_Mig_Fins.sql.

   • Household_Mig_Fins.sql
   • dev0ftp.txt

     Execute this file as part of the procedure described in Deploying Stored Procedures and User-Defined Functions.

   • ftpdev0.bat

     Execute this file as part of the procedure described in Deploying Stored Procedures and User-Defined Functions.

     After executing the SQL files successfully and reviewing the log files for unacceptable errors, you deploy the stored procedures and user-defined functions as described in Deploying Stored Procedures and User-Defined Functions.