1. Database Upgrade Guide for DB2 for z/OS
  2. Transferring the Nonadditive Schema, Temp Table, and Load and Unload Files to the z/OS Host

Transferring the Nonadditive Schema, Temp Table, and Load and Unload Files to the z/OS Host

Use the following procedure to transfer the nonadditive schema DDL files, the Temp table DDL files, and the Load and Unload control cards generated by the Upgrade Wizard on the midtier up to Pause #2 to the z/OS host.

Note: Edit the generated files as required by Siebel Technical Notes, Siebel Alerts and Siebel CRM Update Guide and Release Notes on My Oracle Support, or other publications before transferring them to the z/OS host.

To transfer the files generated on the midtier

  1. Navigate to the \DB2390\dbsrvr\dboutput\upgrade directory (Windows) or the /DB2390/dbsrvr/dboutput/upgrade directory (UNIX) and double-click the ftp_pause2.bat file (Windows) or issue the following command (UNIX):

    ftp -vn < ftp_pause2.txt > ftp_pause2.log

  2. Enter your TSO password and press Enter.

    All the Pause #2 files are transferred from the midtier to the z/OS host.

  3. Review the ftp_pause2.log file which is created in the upgrade directory and verify that all the files listed in the ftp_pause2.txt file transferred successfully to z/OS staging data sets.