Delete/Reload DEFAULT RULESETS with the ssid1025 job in the Highlevel.Control library.

Products

• RC Compare for DB2 for z/OS
• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

Job sssid1025 in the Highlevel.Control library loads and reloads PPA rules tables for the current release of DB2. Why does this job delete all the defaults from @DFLT130' to @DFLT910' (9 rules) but, reloads only @DFLT710', @DFLT810'and @DFLT910' (3 rules)?

Solution:

Job sssid1025 must be run for both install upgrades and maintenance upgrades. It replaces the static rules table PTPS_ES_RU2RE_0107 and deletes/reloads the shipped(internal) default rulesets for each version of DB2. It reloads only @DFLT710', @DFLT810'and @DFLT910' because these are the three releases supported by IBM. PPADB2 can no longer support those old versions of DB2. The job can be run at any time and any number of times. PPA checks for these rules during the Explain process. More details can be found in Chapter 6 of the Implementation Guide under the subheading of Plan Analyzer.

Environment

Release:
Component: PPADB2