What is EZ-Cache?
EZ-Cache is a tool designed to analyze DB2 SQL performance on z/OS. It identifies high CPU use dynamic SQL statements by using data from DB2 MONITOR trace for IFCIDs 316-318. The product is no longer supported and has been merged into EZ-DB2.
How did EZ-Cache analyze DB2 SQL performance?
EZ-Cache utilized DB2 MONITOR trace data, specifically IFCIDs 316-318, to gather performance metrics. This data was then analyzed to pinpoint SQL statements consuming excessive CPU resources. The product is not supported and has been merged into EZ-DB2.
What platform was EZ-Cache designed for?
EZ-Cache was designed to run on the z/OS platform. The product is not supported and has been merged into EZ-DB2.
What is the current status of EZ-Cache?
EZ-Cache is no longer supported. Its functionality has been integrated into EZ-DB2. Users should migrate to EZ-DB2 for continued DB2 SQL performance analysis.