Siebel Database Upgrade Guide for DB2 for z/OS > Performing Postupgrade Tasks on the Target Database >

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 How to Perform 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.