EZ-Alerts

Access Path Monitoring and Alerts

Identifying and fixing rogue SQL statements improves overall system performance. EZ-Alerts highlights Static and Dynamic SQL statements having potentially undesirable access path characteristics such as table scan and non-matching index scan, or that otherwise violate site coding standards. When used in test, QA and production, the quality and consistency of new and existing applications is ensured.

EZ-Alerts provides detailed analysis and reporting directly against an SQL Workload captured by EZ-Tracer or EZ-Cache or against workloads imported into the EZ-DB2 SQL Warehouse.

EZ-Alerts can be used as a tuning tool to identify problematic or high cost SQL in a live environment, and to ensure the integrity of SQL coming from Development.

EZ-Alerts is Workload Aware; results take into account the relative impact of statements within the Workload according to the Workload SQL Distribution. For example, a display of SQL statements performing table space scans will show the SQL sorted in descending cost sequence - allowing the user to zoom-in and fix the statements that have the greatest impact.

EZ-Alerts allows the user to select from a list of predefined Alerts, such as table space scans, non-matching index scans, join more than ‘n’ tables, etc. EZ-Alerts lets the user define Alert thresholds. For example, the user may specify thresholds for table scan, CPU, Get Page and Timeron Alerts.

When used in conjunction with EZ-Impact Analyzer, the user can easily see Alerts that have been changed, added or dropped as a consequence of an environmental change or application modification.