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 are used to complete the development upgrade:

• synctab.sql and syncidx.sql: Synchronize tables and indexes on the development database.
• (7.5.3 upgrades only) dedup.jcl and dedup_prod.jcl: Remove duplicate records from the intersection tables and set 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 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.

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 for upgrades from Siebel CRM version 7.5.3 before the production environment upgrade is started. 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.