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

Optimizing Old-Schema Index Rebuild Jobstreams

Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

To improve performance and reduce the number of jobs run, 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 options 0 and A on the Job-Stream Optimization menu.

To optimize old-schema index rebuild jobstreams

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.

3. Select Option A) 3. GENERATE LIST OF OLD-SCHEMA INDEX REBUILD JOBS and then press Enter.

   This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC3).

4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC3).

   NOTE:  After running this job, verify that it was successful by reviewing the sysout in SDSF or another job output facility and making sure the RC=0.

5. Submit the job, press Enter, and then press PF3.
6. Select Option A) 4. REMOVE OLD-SCHEMA INDEX REBUILD JOBS and press Enter.

   This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC4).

7. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC4).
8. Submit the job, press Enter, and then press PF3 twice.

   The *** UPGRADE <upgrade type> TO 7.8 MAIN MENU *** appears. The panel ID is SPLUPG7P.