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

Preparing the z/OS Data Sets

When you have transferred the files generated by the Siebel Upgrade Wizard up to Pause #1 from the midtier to the z/OS host, allocate and populate the data sets used to execute the upgrade jobs as described in the following procedure.

To prepare the z/OS data sets

1. Go to the Siebel Upgrade Main Menu by entering the following command:

   TSO EXEC 'DSNHLQ.SIEBEL.EXEC'

   The panel ID is SBLUPG8P. You can find the panel ID in the bottom right corner of the screen.

2. On the Siebel Upgrade Main Menu, select option 1: File Generation, and press Enter.

   The Staging Database File Generation Menu is displayed. The panel ID is SBLSFGP.

   
3. Select option 0: Allocate PDS/SEQ Datasets, and press Enter.
4. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(CREATEDS) to allocate data sets.
5. Verify that the job ran successfully and allocated data sets. For information, see Verifying JCL Upgrade Jobs.
6. After submitting the job, enter cancel on the command line or press PF3 to save changes.
7. On the Staging Database File Generation Menu, select option 1: Translate SQL Scripts, and press Enter.

   This option is used to run the JCL to translate SQL scripts. Language-specific data migration SQL types are translated for PRESCHM, UPGIDSS and Gen Primary jobs.

8. Run the job using the JCL in data set DSNHLQ.SIEBEL.SP.CNTL(REC1147) where 1147 varies according to your upgrade path and language. If your primary language is ENU, the job runs in foreground mode. If your primary language is not enu, the job runs in batch mode. RECF1147 is used in the case of French language support.
9. Verify that the job ran successfully as described in Verifying JCL Upgrade Jobs. Check the Bookmark field to verify that the job translated the SQL scripts.
10. On the Staging File Generation Menu, select option 2: Populate PDS/SEQ Datasets, and press Enter.
11. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(UNPACK01).
12. Verify that the job ran successfully as described as described in Verifying JCL Upgrade Jobs. The job return code must be 0, although a return code of 4 is acceptable if the data set is empty.

    Verify that this job populates (unpacks) all PDS members into corresponding PDS data sets and sequential files. It is acceptable to have some empty data sets.

    NOTE:  PDS data sets are populated using IEBUPDTE; sequential files are populated using IEBGENER.