1. Database Upgrade Guide for DB2 for z/OS
  2. Transferring the Staging DDL to the z/OS Host

Transferring the Staging DDL to the z/OS Host

When the Upgrade Wizard stops at Pause # 0, you must transfer the SQL and JCL templates and other staging DDL that has been generated on the midtier to the z/OS host where they can be executed. To do this, perform the following procedure.

To transfer the staging DDL to the z/OS host

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

    ftp -vn < ftp_stg.txt > ftp_stg.log

  2. Enter your TSO password and press Enter.

    All the files required to create the staging database are transferred from the midtier to the z/OS host.

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