Overview
IBM DB2 Path Checker for z/OS provides information about potential access path changes before they occur and about changes that occur after a rebind.
DB2 Path Checker helps you avoid costly performance issues relating to access path changes before they occur.
- Identifies, analyzes and documents potential access path changes in advance without initiating bind processing
- Quickly determines if a bind of a Database Request Module (DBRM) will result in an access path change
- Provides information about potential access path changes before they occur and after a rebind
- Tests proposed or actual changes in plans
- Creates a report of changed and unchanged paths
- Optionally provides cost estimates and DB2 catalog statistics for path changes
- More detailed information provided for error logs and messages that can be used by IBM support to more quickly resolve problems
- Program number: 5697- N57
Case study
Carrefour chooses DB2 Administration Tool for z/OS
Product framework
Family overview
See the complete family of DB2 Tools for z/OS
See how other Data Management Tools can help drive your business
See the DB2 for z/OS page for all your DB2 needs.
Additional products, services and solutions
Products
Automatically eliminates unnecessary binds, processing only the necessary DB2 bind saving valuable resources
Solutions
Identifies access path changes that could affect DB2 performance
We're here to help
Easy ways to get the answers you need.
Or call us at:
877-426-3774
Priority code:
109HF03W