|
Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe >
Transferring the Index Schema to the z/OS 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. Use the following procedure to transfer the index schema and dedup files created by the Upgrade Wizard on the midtier to the z/OS host. To transfer the index schema to the z/OS host
- Navigate to the
DBSRVR_ROOT\DB2390\DBOUTPUT\UPGRADE directory and open the ftpscindx.txt file.
- Replace
&IP with the IP address or name of your z/OS host, for example ZM01.
- Replace
&Username with the your TSO or ID user name, 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, find and double-click the ftpscindx.bat file.
- At the prompt, enter the password for the TSO ID userid specified in Step 3, and then press Enter.
This transfers the SCINDX.SQL file from the midtier to the z/OS host; its host staging dataset name is DSNHLQ.SIEBEL.VSTG0110.
- Review the ftpscindx.log file to verify that all files transferred successfully.
|
