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

Optimizing the Target 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.

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

To improve performance and reduce the number of jobs managed in a one-table-per-tablespace (including partitioned tablespaces) database configuration, you can use an optional feature called Job Steam Optimization (JSO) to remove gen primary index rebuild jobs for tables that contain no data.

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 gen primary index rebuild jobs for tables that contain no data

1. After transferring the index schema to the zSeries host, verify the following JCL members:
   • JSOTARQ
   • JSOTARD

     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 JSOTARQ.

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

3. Review the SDSF output for pre gen primary index rebuilds (non-unique and obsolete).
4. Run the JCL member JSOTARD.

   This member deletes the PDS members and modifies the submission executable.