Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Preparing the z/OS Host Environment >

Transferring JCL, SQL, and Binary Files to the z/OS Host

When the Upgrade Wizard stops at Pause # 1, you must transfer the SQL and JCL templates and the PRET files that have been generated on the midtier to the z/OS host where they can be executed.

Once the files are transferred to the mainframe, they are staging data sets and are assigned a file name with a format of VSTG*. For a list of the files transferred from the midtier and their staging data set names, see Production Upgrade Files Generated by the Upgrade Wizard.

Use the following procedure to transfer files to the z/OS host.

To transfer files to the z/OS host

1. Navigate to your DDL output directory and open the pretftp.txt file.

   Windows: The default DDL output directory is DBSRVR_ROOT\db2390\dboutput\upgrade.

   UNIX: The default DDL output directory is DBSRVR_ROOT/db2390/dboutput/upgrade.

2. Edit the pretftp.txt file using the following information:
   1. Replace &IP with the IP address or name of your z/OS host, for example ZM01.
   2. Replace &Username with the your TSO ID, for example sadmin.
   3. Replace the constant SIEBELQ1 with your own dataset high-level qualifier (DSNHLQ), for example, to your TSO ID or to a DSNHLQ that you have authority to allocate datasets as (such as SK.SBL) using a command like Replace All.

      Use the same high-level qualifier for all z/OS upgrade datasets. The DSNHLQ must be 18 characters or less and can have multiple nodes separated by periods. A node must be one to eight characters in length. The DSNHLQ can be the TSO ID.

3. After modifying the pretftp.txt file, save it, and then close the file.
4. Double-click pretftp.bat (from UNIX issue the following command: Ftp -i > pretftp.bat).

   You are prompted to enter the password for the user name that you entered in pretftp.txt to replace &Username.

5. Enter the password and then press Enter.

   All files generated to this point of the upgrade process transfer from the midtier to the z/OS host.

   The pretftp.log file is created in dbsrvr\db2390\dboutput\upgrade.