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
MouseDrill
Download 'MouseDrill' for Windows.
Click here… for more details and a tutorial for setting it up
Public Webinars & Tech Talks
Extreme Performance Tuning for DB2 LUW
Feb 21, 1PM-2PM EST
More Details…
DB2 z/OS Workload Tuning with EZ-DB2
Feb 27, 12PM-1PM EST
More Details…
Workload Centric Index Optimization with EZ-DB2
March 13, 11AM-12PM EDT
More Details…
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.
Customer Success Stories...
Join A Meeting
Keep Up To Date
Maintenance is published on our support portal at http://my.cogito.co.uk.
Follow us on Twitter - where we will notify you of updates, including maintenance.
Join Team EZ-DB2 at LinkedIn for the latest news and updates for EZ-DB2.





