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

Transferring Control Cards and Schema DDL Files to the z/OS Host

Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

This topic is part of an upgrade process. See How to Perform the Upgrade.

Use the following procedure to transfer the unload and load control cards and schema DDL files generated by the Upgrade Wizard on the midtier up to Pause #2 to the z/OS host.

To transfer files to the z/OS host

1. Navigate to your DDL output directory and open the ftpfile.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 ftpfile.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 variable SIEBELQ1 with the dataset high-level qualifier (DSNHLQ) that you used for all upgrade datasets.

      CAUTION:  This DSNHLQ must match the DSNHLQ specified in your FTP script in Transferring JCL, SQL, and Binary Files to the z/OS Host.

      You must 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 ftpfile.txt file, save it, then close the file.
4. To run the FTP script, locate and double-click the batch file ftpfile.bat (from UNIX issue the following command: Ftp -i > ftpfile.bat).
5. At the prompt, enter the password for the TSO ID user name that you entered in ftpfile.txt, and then press Enter.

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

6. The ftpfile.log file is created in DBSRVR_ROOT\db2390\dboutput\upgrade.