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
- 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. The panel ID is SBLJSOP.
- 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.
- Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC0).
- 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.
- 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).
- Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC1).
- 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.
- 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).
- Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(JSOSRC2).
- Submit the job, press Enter, and then press PF3.
|