Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe >

Optimizing the Target Job Stream, Part 2


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.

To improve performance and reduce the number of jobs managed in a one-table-per-tablespace database configuration, you can use an optional feature called Job Stream Optimization (JSO) to eliminate index rebuild jobs for tables that contain no data.

This section applies to option B (items 5 and 6) on the Job-Stream Optimization menu.

To generate primary rebuilds

  1. If you are not on the Siebel Upgrade Main Menu, enter the following command:

    TSO SBLUPG78

  2. Select Option 4. OPTIMIZATION - JOB-STREAM OPTIMIZATION (OPTIONAL) and then press Enter.

    The UPGRADE <upgrade type> TO 7.8 JOB-STREAM OPTIMIZATION MENU appears.

    NOTE:  If you have not already run Option 0: IDENTIFY "EMPTY" TABLES (REQUIRED-MUST RUN FIRST), you must do so now.

  3. Select Option B) 5. GENERATE LIST OF NEW-SCHEMA (GEN-PRIM) REBUILDS and press Enter.

    This places you in edit mode for PDS dataset and member dsnhlq.siebel.install.jcl (JSOTAR1).

  4. Run the job using the JCL in dataset <DSNHLQ.SIEBEL.INSTALL.JCL(JSOTAR1)>.
  5. Submit the job and then press Enter.
  6. Once you have verified the success of the job, press PF3.
  7. Select Option B) 6. REMOVE NEW-SCHEMA (GEN-PRIM) INDEX REBUILDS JOBS and then press Enter.

    This places you in edit mode for PDS dataset and member dsnhlq.siebel.install.jcl (JSOTAR2).

  8. Run the job using the JCL in dataset <DSNHLQ.SIEBEL.INSTALL.JCL(JSOTAR2)>.
  9. Submit job and then press Enter.
  10. Once you have verified the success of the job, press PF3.
  11. Review the output in SDSF or another job output facility for pre gen primary index rebuilds.
Upgrade Guide for DB2 UDB for z/OS