1. Database Upgrade Guide for DB2 for z/OS
  2. Transferring the Development Environment Upgrade Output Files to the z/OS Host

Transferring the Development Environment Upgrade Output Files to the z/OS Host

Upgrades: All upgrades.

Environments: Development environment only.

This topic is part of an upgrade process. See Performing a Siebel Database Upgrade.

The development upgrade upgphys process generates the following files, which synchronize tables and indexes on the development database, and complete the development upgrade:

  • synctab.sql

  • syncidx.sql

Transfer these files to the z/OS host using the following procedure.

To transfer the development environment upgrade output files 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_syncdd.bat file (Windows) or issue the following command (UNIX):

    ftp -vn < ftp_syncdd.txt > ftp_syncdd.log

  2. Enter your TSO password and press Enter.

    All the development environment postupgrade files are transferred from the midtier to the z/OS host.

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

Note: If the development and production upgrades are run on different midtier computers, then you must copy the files to be transferred to the z/OS host to the production midtier computer before running the ftp_syncdd.bat file.