Published on 30-May-2012
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
IBM DB2 can save you millions. Coca-Cola Bottling Co. Consolidated chose to move to DB2 four years ago, and they have saved more than $1 million since. Because of the savings, ease of use, performance and reliability of the software, they are now in the process of upgrading to DB2 10.
-J.B. Harrison began selling Coca-Cola in bottles
-His great-grandson Frank Harrison, III is chairman and CEO of Coca-Cola Bottling Co. Consolidated
-Now the nation’s largest independent Coca-Cola bottler and a leader in manufacturing, marketing and distribution of a variety of beverage products
Andrew Juarez: People are always trying to save money in different forms or fashions whether it’s buying gas, whether it’s buying food. So we have to be very competitive on how we price our product.
Tom DeJuneas: When the economy started to turn sour in 2008, 2007 timeframe it was a difficult time for the bottlers. We were incurring a lot of additional costs, petroleum products were up, sugar was up and we can’t just pass along that pricing to the consumer.
Andrew Juarez: We needed to look at how to reduce our operating expense. We happened to be going through SAP upgrade, which required us to upgrade our database. And it was a perfect opportunity for us to look at what other opportunities we had out there.
So we basically had several benchmarks that we were looking to achieve. We needed this software to save us money, it also needed to perform very well, it needed to be easy to use, and it needed to be reliable.
We found out that everything was there including a huge cost savings and so we sat down and we quickly made the decision to move to DB2. From day one, the first night we cut over, we had our nightly production runs and that morning we had information from the managers out at the plants saying “Hey, we have got jobs that normally run 90 minutes running in 30 minutes.”
Tom DeJuneas: The manager of the application for our supply chain came into my office and asked me, “What did you guys do last night?” I said, “Well, we migrated our SAP from Oracle to DB2.”
Andrew Juarez: So their next question is can we expect this every night…
Tom DeJuneas: It went from 90 minutes to 30 minutes every night, and they gained an hour back to their batch window. We have gone from 9.1 to 9.5, 9.7 introduced index compression so we saw another 18% to 20% compression. We are beta testing DB2 version 10 right now and the compression has gotten better again, we are going to see another 20% increase.
Andrew Juarez: Initially the thing that really got my attention was I started running some jobs, it normally takes 30 – 36 hours to run and it ran in 2 hours the very first time I tested it on DB2 10. I mean, that’s a 90% savings. This thing eats data for lunch.
Tom DeJuneas: The results of migrating from Oracle to DB2—over these last four years, we’ve seen savings of just north of a million dollars. We are looking forward to going ahead and upgrading our DB2 version to DB2 10, because of the performance gains and the additional compression that we’ve seen during our beta test.
Andrew Juarez: At the end of the day, it allowed us to do more work throughout the plant on a day-to-day basis. So anytime we speed up transactions, it’s a win for us.
Tom DeJuneas: The less money that we spend on running our day-to-day systems frees up money for us to look at more innovative ways of doing business.
Products and services used
IBM products and services that were used in this case study.
DB2 for Linux, UNIX and Windows