Case Study: Grocery Wholesaler and Supermarket Chain achieves up to 50% Db2 CPU savings and avoids mainframe upgrade with Precisely (Syncsort Optimize DB2)

Mainframe Upgrade Avoided by Switching Db2 Tools

Grocery Wholesaler and Supermarket Chain, a Midwest supermarket and wholesale operator, faced Db2 processing that consumed more than half of its mainframe CPU while transaction volumes were growing, putting a costly mainframe upgrade on the table. Existing Db2 tools couldn’t reduce the workload appetite, so the company selected Precisely’s Syncsort Optimize DB2 to find workload-centric savings and avoid the upgrade.

Precisely’s Syncsort Optimize DB2 was installed in under three hours and delivered same-day results by consolidating and ranking functionally identical SQL, enabling what-if cost projections, and identifying all application instances of target statements. Within a month the customer realized over 35% Db2 CPU savings, later extended to 50%, with no adverse performance impact, rapid ROI, and reduced sensitivity to environmental changes.