Case Study: Leading Auto Manufacturer avoids costly CPU upgrade and saves operations costs with Precisely Optimize DB2

Leading Auto Manufacturer - Customer Case Study

Leading Auto Manufacturer, a prestige automaker, faced a sudden crisis when a new distributed web system for dealers generated massive Db2 workloads that pushed CPU usage beyond capacity and forced a costly CPU upgrade. Their IT team needed better ways to track and tune database processing—especially the huge number of identical SQL statements that existing tuning tools could not consolidate—so they evaluated and selected Precisely’s Optimize DB2.

Precisely’s Optimize DB2 consolidated duplicate SQL into single entries, reported total and average CPU for high-frequency statements, and provided program/AuthID reporting, historical tracking, a stats-copy feature to align test and production access paths, and an Impact Analyzer to predict access-path changes. As a result, the Leading Auto Manufacturer avoided another CPU upgrade, saved a “very large amount of money” in ongoing operations, and gained visibility to prevent and diagnose performance regressions.