Contact us online or call (800) 327-9650.
Bind ImpactExpert for DB2 z/OS
Bind ImpactExpert (BIX) provides automated and intelligent management of DB2 binds and rebinds, assuring optimal application performance. Bind ImpactExpert avoids access path degradations, even when you make changes to dynamic SQL.
Bind ImpactExpert proactively determines the access paths associated with rebinds and binds and eliminates the access path unpredictability associated with:
- Rebinds after runstats
- Rebinds required when moving between DB2 releases
- Binds of changed applications
With complete automation, BIX proactively determines access paths resulting from binds and rebinds and pinpoints degradations at the SQL statement level. Using predictive analysis of dynamic SQL, BIX can also determine the production access paths impacts for dynamic SQL as well.
Key Features
- Evaluates access path changes when moving to a new version of DB2
- Automates management of the DB2 bind and rebind processes
- Analyzes access paths instead of relying on DB2 performance ratings
- Easy-to-use ISPF interface that allows in-depth analysis of poor access paths
- Uses a customizable weighting system to compare access paths
- Allows for offending SQL statements to be immediately investigated and corrected
Product News
DB2 9 introduced a new feature that allows fallback to a prior access path based on a backup. BIX has a proactive approach that allows you to automatically predict access path changes before they happen, which is always preferred. In support of the PACKAGE STABILITY feature, BIX now ensures that you can use PACKAGE STABILITY only if you really need it.
Contact us
Request more information >>