Siebel Database Upgrade Guide for DB2 UDB for z/OS > Generating the Siebel Upgrade Files > Preparing and Executing the Non-Additive Schema and JCL Files on the z/OS Host >

Transferring the Non-Additive Schema, Temp table, and Load and Unload files to the z/OS Host


Use the following procedure to transfer the non-additive schema DDL files, the Temp table DDL files, and the Load and Unload control cards generated by the Upgrade Wizard on the midtier up to Pause #2 to the z/OS host.

NOTE:  Edit the generated files as required by Siebel Technical Notes, Siebel Alerts and Siebel Release Notes on My Oracle Support, or other publications before transferring them to the z/OS host.

To transfer the files generated on the midtier

  1. Navigate to the \DB2390\dbsrvr\dboutput\upgrade directory (Windows) or the /DB2390/dbsrvr/dboutput/upgrade directory (UNIX) and double-click the ftp_pause2.bat file (Windows) or issue the following command (UNIX):

    Ftp - i > ftp_pause2.bat

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

    All the Pause #2 files are transferred from the midtier to the z/OS host.

  3. Review the ftp_pause2.log file which is created in the upgrade directory and verify that all the files listed in the ftp_pause2.txt file transferred successfully to z/OS staging datasets.
Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.