Stacks Image 169

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.

Stacks Image 215
Stacks Image 489

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

Cogito is now a Syncsort Company!

Public Webinars & Tech Talks


Download 'MouseDrill' for Windows.

Click here… for more details and a tutorial for setting it up

EZ DB2 is the best thing since shirt pockets and sliced bread combined. Just last month EZ DB2 identified an sql that decided to go south after running for several months ‘with no problems’ and was pegging out both of our machines in data sharing. Quick 5 minute trace to identify bad sql, add an index and minor sql change and problem gone. EZ DB2 to the rescue.
... a Happy EZ-DB2 Customer
Major Consumer Electronics Retailer - Oct 2014

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

Development Partners

Stacks Image 74
Stacks Image 76

Keep Up To Date

Maintenance is published on our support portal at

twitter Follow us on Twitter - where we will notify you of updates, including maintenance.

linkedin Join Team EZ-DB2 at LinkedIn for the latest news and updates for EZ-DB2.