Challenge Db2 processing at this grocery wholesaler and supermarket chain in the American Midwest was taking up more than half the mainframe’s CPU capacity. At the same time, the company’s transaction volume was growing. Something had to give. A costly mainframe upgrade was in the cards unless the company could find a way to bring the Db2 workload under better control — in other words, unless a certain amount of CPU capacity could be recovered from the ongoing Db2 work. The Db2 tools then in use, however, had proved to be not up to the task of dialing back the appetite for CPU time. Solution The company initially engaged with a small outside group to supplement its busy DBA staff and for some stop-gap tuning efforts. Then, after a marketplace survey of Db2 tuning tools, the

Join for free to read