Upgrade Guide for DB2 UDB for z/OS and OS/390 > Tuning the Upgrade Scripts >

Transferring UNIX Files for Use by Upgrade Tuner

Upgrades: All upgrades.

Environments: Production environment only.

Platforms: UNIX only.

This topic is part of an upgrade process. See How to Perform the Upgrade.

To tune a production upgrade under UNIX, you must use file transfer protocol (FTP) to transfer your upgrade files to a Windows machine. Tune your production upgrade scripts in the Windows environment, then transfer your tuned upgrade files back to your UNIX machine.

Scripts generated during production upgrades simplify the file transfer process:

• upgtuner_ftp_get.txt. This script moves the upgrade files from a UNIX machine to a Windows temporary directory. (Development upgrades do not produce upgtuner_ftp_get.txt.)
• upgtuner_ftp_put.txt. This script moves the upgrade files from the Windows temporary directory back to the UNIX machine. (Development upgrades do not produce upgtuner_ftp_put.txt.)

For more information on the Upgrade Tuner, see About Tuning the Production Upgrade Scripts.

To transfer UNIX files for use by Upgrade Tuner

1. In the FTP scripts, replace placeholder parameters with actual values:

   Placeholder	Value
   &HostIP	IP address of UNIX machine
   &Username	Username used to open an FTP session with the UNIX machine (for example sadmin)
   &WindowsTempDir	Location of the temporary directory on the Windows machine (for example c:\temp\tuner)
2. On a Windows machine with the Siebel Upgrade Tuner installed, create a temporary directory for your tuning process (for example c:\temp\tuner).
3. Use file transfer protocol (FTP) or upgtuner_ftp_get.txt to move the following files from your UNIX machine to a temporary directory on the Windows machine:

   File	Source Location on the UNIX machine
   master_PROCESS.ucf	$SIEBEL_ROOT/bin/
   summary.xml	$SIEBEL_ROOT/log/PROCESS/
   driver_PROCESS.ucf	DBSRVR_ROOT/DBPLATFORM/upgrade/VERSION/
   schema*.ddl	DBSRVR_ROOT/DBPLATFORM/
   *.sql	DBSRVR_ROOT/DBPLATFORM/upgrade/VERSION/

4. After you have tuned the upgrade files, use file transfer protocol (FTP) or upgtuner_ftp_put.txt to return the files to the UNIX machine. Verify that the files are placed in the source locations specified in the table above.
5. Review the log file to verify that your file transfer was successful.