Critical Issue First came the emergency. This company, a prestige auto manufacturer, had implemented a new distributed web system for its dealers. Unexpectedly, the system generated huge workloads for the company’s Db2 database, and soon the Db2 CPU usage was enough to cause the entire CPU to grossly exceed capacity, forcing a quick and costly CPU upgrade. Given that experience, the company’s IT management went looking for a better way to track and tune its database processing. They found solutions for tracking and tuning batch and CICS jobs, but managing the web processes and Db2 enclaves presented bigger challenges. In particular, none of the SQL tuning products they tried was able adequately to manage the very large number of identical SQL statements. Solution After a thorou

Join for free to read