1. Database Upgrade Guide for DB2 for z/OS
  2. Transferring the SCINDX.SQL File to the z/OS Host

Transferring the SCINDX.SQL File to the z/OS Host

Use the following procedure to transfer the SCINDX.SQL file generated by the Upgrade Wizard on the midtier up to Pause #3 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 file 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_pause3.bat file (Windows) or issue the following command (UNIX):

    ftp -vn < ftp_pause3.txt > ftp_pause3.log

  2. Enter your TSO password and press Enter.

    The SCINDX.SQL file is transferred from the midtier to the z/OS host.

  3. Review the ftp_pause3.log file which is created in the upgrade directory and verify that the SCINDX file transferred successfully to z/OS staging data sets.