McCormick tastes success with SAP applications with IBM DB2 on IBM Power

Published on 1 Dec 2011

Running SAP applications with DB2 on IBM Power Systems servers has many advantages, including excellent performance, high reliability and easy management.

Charlie Hoppa, Sr. Manager Archiving and Data Integration, McCormick & Company Inc.

Customer
McCormick & Company Inc.

Industry
Consumer Products, Industrial Products

Deployment country
United States

Partner
SAP

Overview

McCormick & Company Inc. is a leading global supplier of spices, herbs, seasonings, specialty foods and flavors. Founded in 1889, the company has its headquarters in Sparks, MD. It operates in more than ten countries, employs 8,000 people, and generated revenues in 2009 of $3.19 billion.

Business need
McCormick’s SAP ERP landscape is at the heart of its business, and supports almost all of the company’s most critical processes. Any downtime costs money – especially during peak sales periods such as the run-up to Christmas. To minimize the impact on the business, the IT team constantly looks for ways to improve availability and reduce backup and maintenance windows.

Solution
McCormick is upgrading its production SAP environment to IBM DB2 9.7 and replacing its older servers with new IBM POWER7 processor-based machines. The company is using advanced features of DB2 such as compression, self-tuning memory management (STMM) and online reorgs to minimize downtime, simplify administration, reduce storage costs and boost performance.

Benefits
Planned maintenance windows have been reduced by 20 percent, keeping systems available for users and avoiding business disruption. DB2 row compression has reduced database sizes by between 46 and 52 percent, saving storage costs and reducing backup times from 24 hours to just ten. The ability to perform database reorgs online eliminates up to 20 hours of downtime per year. STMM and other automation features minimize workload for database administrators.

Components

IBM products and services that were used in this case study.

Software
AIX, DB2 for Linux

Hardware
Power Systems, Power Systems running AIX 6

Services
IBM-SAP Alliance

Solution
Business Resiliency, Enterprise Resource Planning, High Availability, Information Governance

Legal information

ContactUs Case Studies on your mobile device

Join the Conversation



TwitterGoogle YouTube