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
- If you are not on the Siebel Upgrade Main Menu, enter the following command:
TSO SBLUPG78
- 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.
- 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).
- Run the job using the JCL in dataset <DSNHLQ.SIEBEL.INSTALL.JCL(JSOTAR1)>.
- Submit the job and then press Enter.
- Once you have verified the success of the job, press PF3.
- 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).
- Run the job using the JCL in dataset <DSNHLQ.SIEBEL.INSTALL.JCL(JSOTAR2)>.
- Submit job and then press Enter.
- Once you have verified the success of the job, press PF3.
- Review the output in SDSF or another job output facility for pre gen primary index rebuilds.
|