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.
After a thorough vendor and solution search they found Elevate DB2, from Syncsort Inc.
In testing with Elevate DB2, it was discovered that the SQL statements that were causing the performance problems were not, as suspected, the most complex ones. They were instead some of the very frequently executed SQL even though each one individually used relatively small amounts of CPU.
Elevate DB2 enabled them to consolidate identical SQL statements, so that instead of a million separate lines of the same SQL statement, they had one line showing a single SQL statement being executed a million times. Elevate DB2 also showed the total of CPU time used by the SQL statement, as well as the average time.
Elevate DB2 was an easy choice for them just based on their immediate need, and they indicated interest in other components of the Elevate DB2 suite for solving longer-term problems as well.
Following Elevate DB2 implementation, the company counted the following as the most notable benefits: