Automate Bind and Rebind Control

Impact Expert (patented #EU1353278) automatically determines the performance impact of BINDs and REBINDs on packages in advance. This automation assists the DBA in eliminating access path degradation in the following circumstances:

• Nightly maintenance, i.e., REBIND after RUNSTATS.
• Hand-over of changed applications into production, i.e., pre-checking the effect of the changes on the access paths before the BIND.
• Migration to new DB2 releases and application of APARs, or anytime when global REBINDs are recommended.
• New functionality automatically secures access to the DB2 V8 migration path in advance >> EarlyPrecheck

Features

• Guarantees safe REBINDs by providing timely recognition of the possible consequences of REBINDs on access paths in advance.
• Supports BIND control by automatically identifying the BIND impact of a new DBRM in advance.
• Integrates into the production maintenance to allow only REBINDs that are guaranteed to improve access paths.
• Reduces locks on the catalog by eliminating unnecessary REBINDs, which account for up to 75% of all REBINDs.
• Processes all types of BIND and REBIND PACKAGE statements.
• Runs stand-alone to process packages and whole collections and generates REBIND statements for packages whose access paths would be improved by the REBIND.
• Uses a customizable weighting system to compare access types.
• Logs and displays all impact evaluations in an ISPF online interface.
• Optional interface to Analyze+ provides full EXPLAIN functionalities using an extensive rule system to find coding violations and provide recommendations.

ImpactExpert - Interactive Demonstration ( swf | exe )

ImpactExpert - Product Description (PDF, 82 KB)

ImpactExpert - New Functionality / zProductProfile (PDF, 80.9 KB)