DB2 Path Checker for z/OS

IBM DB2 Path Checker is designed for the process of developing and implementing applications that are robust and reliable and as efficient and free of problems as possible. DB2 Path Checker gives both DB2 developers and database administrators the ability to identify potential access path changes before they occur. A major problem faced in any DB2 environment is dealing with performance issues that come from unexpected access path changes. DB2 Path Checker allows you to see what access path changes might occur because of development, migration, or system activities, and lets you select a course of action before the changes affect the production DB2 environment. DB2 Path Checker also helps DBAs to verify changes to access paths, reducing the risks of poor performance.

• 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

• Identifies unnecessary rebinds due to application changes that does not affect access path