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

Transferring Control Cards and Schema DDL Files to the zSeries 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.

The following procedure transfers control cards and schema DDL files to the zSeries host.

To transfer files to the zSeries host

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

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

   UNIX: The default DDL output directory is $SIEBEL_ROOT/dbsrvr/db2390/dboutput/upgrade.

2. Edit the ftpfile.txt file using the following information:
   1. Replace &IP with the IP address or name of your zSeries 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 zSeries Host.

      You must use the same high-level qualifier for all zSeries 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 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 zSeries host.

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