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 Additive Schema SQL and JCL Templates

Perform the following procedure to prepare the additive schema files.

To prepare additive schema SQL and JCL templates

1. On the Staging Database File Generation Menu, select option 3: Process Additive Components, and press Enter.

   The Staging Database Additive Schema Menu appears. The panel ID is SBLADMP.

2. Select option 0: Build Additive JCL/Schema, and press Enter,

   Status messages are displayed as the additive components are built.

3. On the Staging Database Additive Schema Menu, select option 1: Populate JCL/Schema PDS Datasets, and press Enter.
4. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(UNPKADD).
5. Verify that the job ran successfully:
   1. Review the output in SDSF or another job output facility. Verify that the return code is 0 and 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.
   2. Verify that this job populated the JCL and schema PDS data sets.
6. After submitting the job, enter cancel on the command line or press PF3 to save changes.
7. On the Staging Database Additive Schema Menu, select option 2: Add Jobcards & Siebel Logging, and press Enter.
8. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBJCL12).
9. Verify that the job ran successfully. The JCL jobcard counts are displayed by job type. The number of jobs that are build for the additive components varies according to your upgrade path.

   Carefully review the output in SDSF or another job output facility. Verify that the return code is 0 and 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.

10. After submitting the job, enter cancel on the command line or press PF3 to save changes.
11. On the Staging Database Additive Schema Menu, select option 3: Load Siebel Log Entries (3), and press Enter. This option runs the job to load the Siebel logging table with additive entries for staging jobs.
12. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(LOADLOG2).
13. Verify that the job ran successfully:
    1. Review the output in SDSF or another job output facility. Verify that the return code is 0 and 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.
    2. Verify that additional log entries have been loaded to the TMP_SBLLOG_TAR table on the staging database.
14. After submitting the job, enter cancel on the command line or press PF3 to save changes.
15. On the Staging Database Additive Schema Menu, select option 4: Additive Schema Status, and press Enter.

    The Additive Schema Status panel is displayed. The panel ID is SBLSADLP. A list of the additive schema members is displayed and their staging status, either PENDING or COMPLETED.

16. To view a member in browse mode, select the member by entering any nonblank character in the Opt column for the member (you can select more than one member to view on each panel).
17. Press Enter. If you selected more than one member to view, press PF3 to move to the next member.