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.
Get installation help, release notes and more.
Count on CA
Standardize on CA Technologies and Save
By optimizing our mainframe management processes, we can grow our business and revenues.
Tom Laudati, Chief Technology Officer, Blue Hill Data Services
Education & Training
Sharpen your skills with training, certifications and resources that can transform your company and career.