Products

Solutions

Education & Training

Services & Support

Partners

Company

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

CA SQL Performance Suite for DB2® for z/OS®

Automatically detect and stop an inefficient SQL statement from moving into production.

View eBook View Data Sheet

Related Videos


Automatically detect and stop an inefficient SQL statement from moving into production.

Quickly identify ineffective SQL statements and recommend changes based on expert rules. Access path, SQL performance and Db2® object usage history can be stored for trending and analysis. Application change control procedures can automatically detect and stop an inefficient SQL statement before it impacts Db2® systems—saving you money on costs aligned to high CPU usage and reducing the risk of slow performing applications.



Benefits

Help ensure optimal SQL performance.

Automatically detect and stop an inefficient SQL statement from moving into production.

Easily identify resource consumers.

Identify frequently used objects that should be isolated to prevent contention.

Save time tuning SQL performance with automation.

Provide data that helps improve tuning with online and historical reporting.

Dependability You Can Trust – SQL Performance Optimization Made Simpler

Our performance management solutions are flexible, and give you choice without giving up control.  You can utilize full automation where appropriate, powerful manual control when desired or expert software-guided assistance. You can help reduce the cost and risk associated with Db2® version upgrades, streamline workflows, use available skill sets better, make more precise updates and improve responsiveness across complex database and application environments.



Featured Case Studies

Featured Products

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.

Support

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

Community

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

Education & Training

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

Getting Started



 

Get answers before purchasing.

Talk to an expert > Find a CA Partner >
 

Add to an existing CA Product.

Find Technology Partner >

Stay updated on Mainframe, and subscribe today.

At CA, your time and privacy are as important to us as they are to you. We use the information you provide under our legitimate interests to make sure you view topics of interest to you. If we got it wrong, please update your preferences. Read our privacy statement to learn more on how we use your personal information.

Get in touch with CA.

Contact Us

We're here to help move your business forward.

View more ways to contact us >