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
- Go to the SIEBEL_ROOT\DBSRVR\DB2390\DBOUTPUT\UPGRADE directory.
- Open the
ftpscindx.txt file.
- Replace
&IP with the IP address or name of your zSeries host, for example ZM01 .
- Replace
&Username with the your TSO, for example sadmin .
- 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.
- After modifying the
ftpscindx.txt file, save it, and then close the file.
- To run the FTP script, double-click the
ftpscindx.bat file.
- 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:
|
zSeries Host Staging Dataset Name |
SCINDX.SQL
|
DSNHLQ.SIEBEL.VSTG0110 |
dedup.jcl
|
DSNHLQ.SIEBEL.VSTG0080 |
dedup_prod.jcl
|
DSNHLQ.SIEBEL.VSTG0081 |
- Review the
ftpscindx.log file to verify that all files transferred successfully.
- Run the Database Configuration Wizard.
|