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

Optimizing the Source Database Job Stream

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 (including paritioned tablespaces) database configuration, you can use an optional feature called Job Stream Optimization (JSO) to remove unload, load, and index rebuild jobs for tables that contain no data.

CAUTION:  Do not perform this task if your environment has multiple tables per tablespace.

NOTE:  This process is irreversible unless you make a copy of your datasets before deleting jobs that act on tables containing no data.

The jobs are located in DSNHLQ.SIEBEL.INSTALL.JCL.

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

1. After preparing Siebel-Scheduled jobs on the zSeries host, verify the following JCL members:
   • JSOSRCQ
   • JSOSRCD

     These members are new in Release 7.7, and substitutions were applied to them on the midtier for source and target DB2 subsystems and tableowners.

2. Run the JCL member JSOSRCQ.

   This member produces a source candidate list of tables that are empty.

3. Review the SDSF output for unload, load, and old schema index rebuild jobs (non-unique and obsolete).
4. Run the JCL member JSOSRCD.

   This member physically deletes the JCL for every empty table, unload, load, and index rebuild jobs. The unload and load control cards are not deleted.