Workload-Centric SQL Tuning for DB2
EZ-DB2 takes a unique end-to-end ‘Workload-Centric & Workload-Aware’ approach to performance optimization. The EZ-DB2 approach first captures an SQL Workload then identifies ‘top-n’ SQL statements by Consolidating statistics (e.g. total CPU consumed) across all instances of like SQLs in the Workload. EZ-DB2 Consolidates statistics for ’otherwise identical’ statements even when such statements have different literals and other variable information. In effect, EZ-DB2 determines how the Workload is distributed across its Consolidated SQL statements (“Workload SQL Distribution”) then provides the tools to leverage this information to help better manage and optimize Workload performance.
EZ-DB - Operational Advantage for CA IDMS
The EZ-DB solutions for CA IDMS operational advantage are among the leading third party tools for CA IDMS. The EZ-DB tools are in use at many of the world's largest CA IDMS installations. One EZ-DB user is ranked, according to the Winter Corporation's survey of very large databases, as having the second largest OLTP database on any platform.The EZ-DB solutions for CA IDMS include solutions for 24x7 update availability during backups, database reorgs and restructures.
Latest News & Events
Download 'MouseDrill' for Windows.
Click here… for more details and a tutorial for setting it up
See how the US division of a prestige European automobile manufacturer achieved savings of over 25% of its DB2 CPU utilization by using EZ-DB2.