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.
McCormick & Company Inc.
Consumer Products, Industrial Products
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.
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.
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.
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.
IBM products and services that were used in this case study.
AIX, DB2 for Linux
Power Systems, Power Systems running AIX 6
Business Resiliency, Enterprise Resource Planning, High Availability, Information Governance
IBM Deutschland GmbH D-70548 Stuttgart ibm.com/solutions/sap IBM, the IBM logo, and ibm.com are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. A current list of other IBM trademarks is available on the Web at “Copyright and trademark information” at http://www.ibm.com/legal/copytrade.shtml Intel, the Intel logo, Intel Xeon and the Intel Xeon logo are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. UNIX is a registered trademark of The Open Group in the United States and other countries. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Other company, product or service names may be trademarks, or service marks of others. This case study illustrates how one IBM customer uses IBM and/or IBM Business Partner technologies/services. Many factors have contributed to the results and benefits described. IBM does not guarantee comparable results. All information contained herein was provided by the featured customer and/or IBM Business Partner. IBM does not attest to its accuracy. All customer examples cited represent how some customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics will vary depending on individual customer configurations and conditions. This publication is for general guidance only. Photographs may show design models. © Copyright IBM Corp. 2011. All rights reserved.