Siebel Database Upgrade Guide for DB2 UDB 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.

To prepare the z/OS data sets

1. Go to the Siebel 8.0 Upgrade Main Menu by entering the following command and pressing Enter:

   TSO SBLUPG80

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

2. On the Siebel Upgrade 8.0 Main Menu, select option 1: File Generation, and press Enter. The Staging Database File Generation Menu panel 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 dataset DSNHLQ.SIEBEL.INSTALL.JCL(CREATEDS) to allocate datasets.
5. Verify that the job ran successfully:
   1. Review the output in SDSF or another job output facility. Verify that the RC=0 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
   2. Verify that this job allocated datasets.
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, PRODCFG, UPGIDSS and Gen Primary jobs.

8. Run the job using the JCL in data set DSNHLQ.SIEBEL.SP.CNTL(RECxxxxx) where xxxxx 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 non-enu, the job runs in batch mode.
9. Verify that the job ran successfully:
   1. Review the output in SDSF or another job output facility. Verify that the RC=0 and that the JCLTEST return code=FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
   2. 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 dataset DSNHLQ.SIEBEL.INSTALL.JCL(UNPACK01).
12. Verify that the job ran successfully:
    1. Review the output in SDSF or another job output facility. Verify that the RC=0. A RC=4 is acceptable if the dataset is empty.
    2. Verify that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
    3. Verify that this job populates (unpacks) all PDS members into corresponding PDS datasets and sequential files. It is acceptable to have some empty datasets.

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