Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Mainframe >

Transferring the Index Schema to the zSeries Host

Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

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

The following procedure transfers the index schema to the zSeries host.

To transfer the index schema to the zSeries host

1. Go to the SIEBEL_ROOT\DBSRVR\DB2390\DBOUTPUT\UPGRADE directory.
   1. Open the ftpscindx.txt file.
   2. Replace &IP with the IP address or name of your zSeries host, for example ZM01.
   3. Replace &Username with the your TSO, for example sadmin.
   4. Replace the constant SIEBELQ1 with the dataset high-level qualifier (DSNHLQ) to be used for all upgrade datasets. The DSNHLQ must be 18 characters or less and can have multiple nodes, separated by a period. A node must be 1-8 characters in length.

      The DSNHLQ can be the TSO ID.

      NOTE:  The DSNHLQ you use must match the DSNHLQ you used in Step 2.

   5. After modifying the ftpscindx.txt file, save it, and then close the file.
2. To run the FTP script, double-click the ftpscindx.bat file.
3. At the prompt, enter the password for the TSO ID specified in Step 1, and then press Enter.

   This transfers all files generated to this point in the process from the midtier to the zSeries host:

   Midtier File Name	zSeries Host Staging Dataset Name
   SCINDX.SQL	DSNHLQ.SIEBEL.VSTG0110
   dedup.jcl	DSNHLQ.SIEBEL.VSTG0080
   dedup_prod.jcl	DSNHLQ.SIEBEL.VSTG0081

4. Review the ftpscindx.log file to verify that all files transferred successfully.
5. Run the Database Configuration Wizard.