Bookshelf Home | Contents | Index | PDF     

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

Optimizing the Target Job Stream, Part 1

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 unload and load jobs for tables that contain no data.

CAUTION:  Do not perform this task if your environment has multiple tables per tablespace. This process is irreversible unless you make a copy of your datasets before deleting jobs that act on tables containing no data.

This section applies to options 0 and A on the Job-Stream Optimization menu.

To remove unload and load jobs for tables that contain no data

  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. The panel ID is SBLJSOP.

  3. Select Option 0: IDENTIFY "EMPTY" TABLES (REQUIRED-MUST RUN FIRST) and then press Enter.

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

    NOTE:  This option is only available if your source database follows the 1:1:1 database schema structure.

  4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC0).
  5. Submit the job, press Enter, and then press PF3.

    NOTE:  Verify the return code to make sure the job ran successfully before proceeding to the next step.

  6. Select Option A) 1. GENERATE LIST OF UNLOAD/LOAD JOBS and then press Enter.

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

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

    NOTE:  Make sure the job ran successfully by verifying the return code before proceeding to the next step.

  9. Select Option A) 2. REMOVE UNLOAD/LOAD JOBS and then press Enter.

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

  10. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC2).
  11. Submit the job, press Enter, and then press PF3.
    
Upgrade Guide for DB2 UDB for z/OS