Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Preparing the Schema and JCL Files on the z/OS Host >

Applying DSNHLQ to FTP DDL, Unload Cards, and Load Cards

Perform the following task to apply the dataset name high-level qualifier (DSNHLQ) to your FTP DDL, unload cards, and load cards.

To apply DSNHLQ to DDL and unload/load files

1. On the Siebel Upgrade Main Menu, select option 3: SCHEMA/JCL - BUILD DDL AND JCL-PREP FOR UPGRADE.

   The SCHEMA/JCL MENU appears. The panel ID is SBLUPGP.

2. On the Schema/JCL Menu, select option 0 (CHANGE UNLOAD/LOAD JCL TEMPLATES - SET DSNHLQ), and then press Enter.

   NOTE:  This option must be run first and can be run only once. If you attempt to rerun this option, the following message appears: CHANGE UNLOAD/LOAD JCL TEMPLATES - SET DSNHLQ HAS ALREADY BEEN RUN/APPLIED. OPTION 0 CANNOT BE RERUN.

   The message STAGING dataset/TEMPLATE MODIFICATIONS IN PROGRESS appears.

   Additional messages that appear:

   • DROP STATEMENTS WILL BE BUILT FOR OPTIONAL USE:

     BUILDING - DROP DATABASE STATEMENTS

     BUILDING - DROP TABLESPACE STATEMENTS

     BUILDING - DROP TABLE STATEMENTS

     BUILDING - DROP INDEX (UNIQUE ONLY) STATEMENTS

     BUILDING - DROP INDEX (NON-UNIQUE ONLY) STATEMENTS

     BUILDING - DROP INDEX (OBSOLETE ONLY) STATEMENTS

   • UNLOAD/LOAD DEFAULT DSNHLQ SUCCESSFULLY CHANGED TO: DSNHLQ ; PROCEED TO THE PDS/SCHEMA/VERIFICATION UTILITIES PANEL; RUN OPTION 1: BUILD/POPULATE UNLOAD/LOAD PDS DATASETS; (UNPACK02) ; MESSAGE: SBLSETV-0007
3. Press Enter to return to the Schema/JCL Menu.

   The Schema/JCL Menu appears.