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

Transferring the Nonadditive Schema, Temp Table, and Load and Unload Files to the z/OS Host


Use the following procedure to transfer the nonadditive 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 data sets.
Siebel Database Upgrade Guide for DB2 for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.