CA Database Administration Suite for z/OS vs IDERA SQL Workload Analysis comparison

CA Database Administration Suite for Db2® for z/OS® automates routine administrative tasks while keeping complete control of the database environment in your hands. It helps reduce costs, simplifies Db2® Object Schema and data management and helps provide for the integrity of your Db2® environments. This solution increases database availability through automation, and helps you to easily perform complex database administration tasks.

Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. With the SQL Workload Analysis add-on, continuously monitor and analyze server workload, leverage the simple user interface that focuses on wait states and application performance, and troubleshoot problematic SQL code from changes made to database applications. Perform real-time analysis with continuous SQL sampling intervals. Know instantly where databases are spending time. Quickly isolate slow SQL statements and drill down for actionable advice. Investigate historical query plan trends. Utilize automatic recommendations to improve query performance.