Products

o    Overview

o    CA for Developers

o    Modern Software Factory Hub

o    Industry Solutions

o    Advanced Analytics

o    Agile Management

o    API Management

o    Automation

o    Cloud Solutions

o    Continuous Delivery

o    Continuous Testing

o    DevOps

o    IT Operations Management

o    Mainframe

o    Microservices

o    Security

o    Service Management

o    Veracode

o    Overview

o    Log in to Training Portal

o    Course Finder

o    Learning Paths

o    Free Training

o    New Releases

o    Specialized Training

o    CA Agile Training

o    CA Agile Academy

o    API Academy

o    Mainframe Training

o    CA Certification

o    CA Productivity Accelerator

o    How to Buy

o    Locations and Contacts

o    CA+ Video Learning Library

o    Consulting

o    Implementing

o    Managing

o    Upgrading

o    CA Agile Transformation Consulting

o    CA Agile Coaching

o    CA Project & Portfolio Management Services

o    Overview

o    Partner Experience Platform

o    Become a Partner

o    CA Advantage Partner Program

o    Partner Locator

o    Managed Service Providers

o    Regional Resellers

o    Technology Partners

 

 

{{search ? 'Close':'Search'}}

CA Plan Analyzer® for DB2 for z/OS

Provide efficient and easy-to-understand DB2 plan analysis.

Read eBook View Data Sheet

Related Videos


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.

Comparison processing

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


Education & Training Icon

Education & Training

Sharpen your skills with training, certifications and resources that can transform your company and career.

Services & Support Icon

Services & Support

Accelerate your success with help that’s timely and targeted.

Services

Leverage the knowledge of CA Services professionals to get more from your CA solution.

See how >

Support

Troubleshoot technical issues, browse the latest product documentation and access support announcements.

Search knowledge base >

Community

Find answers and share knowledge with your peers through interactive forums.

Join the conversation >

Add to an existing CA product

Find a Technology Partner >

Get in touch with CA.