Published on 02-Apr-2012
Validated on 07 Oct 2013
"We’ve saved more than a million dollars over the past four years by migrating to DB2." - Tom DeJuneas, IT Team Manager, Coca-Cola Bottling Co. Consolidated (CCBCC)
Coca-Cola Bottling Co. Consolidated (CCBCC)
IBM Business Partner:
In 2007, rising commodity and gas prices increased the cost to manufacture and deliver beverage products. For Tom DeJuneas, IT team manager at CCBCC and a 25 year IT veteran, reducing IT costs was critical in helping the company maintain profitability despite these increases. By moving its SAP application for enterprise resource planning from Oracle Database to IBM DB2, the IT team saved nearly a million dollars over four years. Today, CCBCC plans to upgrade to DB2 10, which it expects will provide another 20 percent increase in storage compression and tremendous gains in runtimes.
CCBCC sought to reduce operational costs so it could maintain profitability without raising prices. The company’s IT team had just begun to upgrade its SAP application, which required it to upgrade its Oracle Database.
CCBCC migrated to IBM DB2 to reduce licensing, maintenance and storage costs and improve database performance. In its continuing quest to improve operational efficiency, CCBCC participated in the IBM DB2 10 beta test program and plans to upgrade to the new version for continued savings.
Approximately USD1 million in savings; Between 30-60 percent faster performance for many day-to-day transactions; More than 40 percent reduction in database size with an additional 20 percent reduction expected with DB2 10
Coca-Cola Bottling Co. Consolidated (CCBCC) is the nation’s largest independent bottler of Coca-Cola products, helping bring to market one of the world’s best known and best selling soft drink brands. Through five production centers and 46 distribution centers, CCBCC makes, sells and distributes Coca-Cola and other beverages to stores, restaurants, entertainment venues, offices and college campuses.
In 2007, rising commodity and gas prices increased the cost to manufacture and deliver beverage products. For Tom DeJuneas, IT team manager at CCBCC and a 25 year IT veteran, reducing IT costs was critical in helping the company maintain profitability despite these increases.
“It was a difficult time for the bottlers,” says DeJuneas. “We incurred a lot of additional costs and we can’t pass that pricing to consumers. The best way for us to keep profits up is to cut operating expenses.”
The company’s IT team had begun to upgrade its SAP application for enterprise resource planning when it saw an opportunity to save nearly a million dollars.
“We had run SAP on Oracle Database for many years,” says Andrew Juarez, SAP lead basis and database administrator (DBA) at CCBCC. “We were upgrading our SAP application, which required us to upgrade our database. It was a perfect opportunity to review our options.”
Adds DeJuneas, “I couldn’t believe the price advantage with IBM DB2®. I presented the savings to our director and CIO. The previous year, we migrated our SAP systems from HP to IBM Power Systems™ for improved price/performance and we felt that the process would be similar, and, therefore, the risk was low.”
The migration to DB2 took only five months. Since the initial deployment, CCBCC has upgraded to take advantage of the latest DB2 data compression and performance features.
“When we first migrated to DB2 9.1, we reduced our database size by 40 percent,” says DeJuneas. “We have seen continued improvement with subsequent versions, achieving another 18 to 20 percent compression with each upgrade.”
Performance improvements have been noticeable as well. “We can process more data, more quickly,” says Juarez. “Many day-to-day transactions now run 30 to 60 percent faster and one SAP test program that our systems staff uses runs up to 90 percent faster. Data is also fed into our supply chain system nearly 65 percent faster, which helps our drivers leave the warehouse on time.”
DBA productivity also increased. “It is much easier to maintain DB2 as compared to our previous database,” adds DeJuneas. “It is equivalent to adding half a DBA to my team.”
In its continuing quest to improve operational efficiency, CCBCC plans to upgrade to DB2 10. As with each prior DB2 release, DeJuneas says, he has seen significant performance and compression improvements during the DB2 10 beta test.
“We expect to see another 20 percent increase in storage compression, which means that we can continue to expand our SAP data without adding new storage systems,” says DeJuneas. “We’ve also seen tremendous gains in runtimes with DB2 10.”
CCBCC has realized significant savings with its move to IBM DB2—savings that helps consumers continue to enjoy their favorite beverages without having to pay more.
“We’ve saved more than a million dollars over the past four years in licensing, maintenance and storage costs by migrating to DB2,” says DeJuneas. “We’ve reinvested these savings into other business projects while keeping our operating expenses flat. As a result, we don’t have to pass rising costs on to consumers, which allows us to maintain our sales volumes and market share.”
For more information
To learn more about IBM DB2 on IBM Power Systems, please contact your IBM sales representative or IBM Business Partner, or visit the following websites:
ibm.com/software/data/db2 or ibm.com/power
Products and services used
© Copyright IBM Corporation 2012 IBM Corporation Software Group Route 100 Somers, NY 10589 Produced in the United States of America April 2012 IBM, the IBM logo, ibm.com, DB2 and Power Systems are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml The content in this document (including currency OR pricing references which exclude applicable taxes) is current as of the initial date of publication and may be changed by IBM at any time. Not all offerings are available in every country in which IBM operates. The performance data and client examples cited are presented for illustrative purposes only. Actual performance results may vary depending on specific configurations and operating conditions. It is the user’s responsibility to evaluate and verify the operation of any other products or programs with IBM products and programs. THE INFORMATION IN THIS DOCUMENT IS PROVIDED “AS IS” WITHOUT ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF NON-INFRINGEMENT. IBM products are warranted according to the terms and conditions of the agreements under which they are provided. Statements regarding IBM’s future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.