CA Plan Analyzer for DB2 for z/OS allows you to bypass frustrating and time-consuming methods for plan analysis such as the DB2 EXPLAIN facility, the PLAN_TABLE output or catalog statistics collection.
Determine which access paths DB2 has chosen and why with easy-to-understand reports and the ability to customize the individual skill levels.
CA Plan Analyzer® for DB2 for z/OS. Real results, right now.
Provides SQL performance recommendations
Identifies problems and provides recommendations for SQL plans and predicates.
Identifies changes to access path and SQL cost.
Supports IBM® DB2 Accelerator
Manages queries to facilitate processing on the IBM DB2 Accelerator.