Cogito Homepage

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.