 |
|
|
|
 |
DB2 Rebind |
|
|
Bind ImpactExpert™
 The DB2 rebind and bind processes are intended to improve application performance, but sometimes a bind or rebind makes things worse. Bind ImpactExpert provides automated and intelligent management of DB2 binds and rebinds, assuring optimal application performance. Bind ImpactExpert avoids surprises, even when you make dynamic SQL access path changes.
The prescribed method for maintaining DB2 performance is the three Rs—reorganize, run statistics, and rebind. However, rebinding does not always produce DB2 performance improvements—in fact, rebinding can cause DB2 performance to degrade. Typically, 75% to 90% of all rebinds are unnecessary. Bind ImpactExpert manages the bind and rebind processes to assure optimal application performance by.
Eliminate the unpredictability of rebinds when moving between DB2 releases. The EarlyPrecheck feature assists you in moving to new DB2 releases. The EarlyPrecheck feature allows you to evaluate and correct access path problems for both dynamic and static SQL prior to an actual DB2 version upgrade. You can perform access path evaluation weeks or months prior to the migration date to allow for in-depth analysis and pre-emptive correction of access path issues.
Eliminate the unpredictable results of rebinds that database administrators experience daily. By filtering out the rebinds that are likely to have a negative impact on DB2 performance, Bind ImpactExpert guarantees improved or consistent performing DB2 applications.
Stop unnecessary binds. By determining whether a DBRM contains changed SQL and skipping the bind step for those that do not. This process eliminates unnecessary binds, optimizes and accelerates the compile procedure, reduces CPU usage, and reduces locks to the DB2 catalog.
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 |
|
|
| • |
Evaluates program changes to determine if SQL changes have occurred and eliminates unnecessary binds |
|
|
| • |
Easy to install and use |
|
|
| • |
Integrates with SQL PerformanceExpert
for immediate and in-depth diagnosis |
|
|
|
|
