Siebel Database Upgrade Guide for DB2 UDB for z/OS > Performing Post-Upgrade 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 are used to complete the development upgrade:

• synctab.sql and syncidx.sql: Synchronize tables and indexes on the development database
• dedup.jcl and dedup_prod.jcl: Remove duplicate records from the intersection tables and sets up support for database aggregation

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 - i > ftp_syncdd.bat

2. Enter your TSO ID and password and press Enter.

   All the development environment post-upgrade 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 datasets.

NOTE:  If the development and production upgrades are run on different mid-tier machines, then you must copy the files to be transferred to the z/OS host to the production mid-tier machine before running the ftp_syncdd.bat file.

About the Dedup Files

The dedup files and dedup_prod.jcl files generated by the upgphys process are similar to the files that you generate during the Prepare for Production Upgrade process, which is run before starting the production environment upgrade. Since both processes use the same information when generating these files, you can use the dedup files created by either the upgphys process or the Prepare for Production Upgrade process.