Parazelsus leverages DB2 High Availability Disaster Recovery (HADR) for its SAP environment

Published on 29-Mar-2011

Validated on 18 Jul 2013

"The IBM Power servers and DB2 database both provide excellent scalability and can sustain our business requirements going forward. Overall we are very happy with the solutions that SAP and IBM have provided for Parazelsus Indonesia. " - Iqbal Syahrial, Senior IT Manager, Parazelsus

Customer:
Parazelsus Indonesia

Industry:
Wholesale Distribution & Services

Deployment country:
Indonesia

Solution:
Business Resiliency, Enterprise Resource Planning, High Availability , Optimizing IT, Optimizing IT

IBM Business Partner:
SAP

Overview

Parazelsus Indonesia is an industry-leading distributor of pharmaceuticals, managing more than 45,000 sales orders every month from a variety of sales channels including the web, SMS and telephone. The company uses advanced supply chain management, warehousing, transport and cold chain capabilities to ensure rapid, efficient delivery of pharmaceuticals across a very widely dispersed customer base.

Business need:
With more than 45,000 sales orders received every month from a variety of sales channels including the web, SMS and telephone, Parazelsus needed to ensure high availability, scalability, along with effortless and quick disaster recovery and a system that could provide low total cost of ownership.

Solution:
Parazelsus decided to migrate its SAP ERP enterprise software from Oracle database to IBM DB2 database software and selected IBM Power 550 and Power 520 servers with POWER6 processors. The migration took two weeks, from planning to completion.

Benefits:
Disaster recovery now takes just fifteen minutes. IBM DB2 offers lower total cost of ownership, high availability and improved disaster recovery capabilities. The integrated DB2 Cockpit for SAP makes management easy and efficient.

Case Study

Parazelsus Indonesia is an industry-leading distributor of pharmaceuticals, managing more than 45,000 sales orders every month from a variety of sales channels including the web, SMS and telephone. The company uses advanced supply chain management, warehousing, transport and cold chain capabilities to ensure rapid, efficient delivery of pharmaceuticals across a very widely dispersed customer base.

The company bases its core business operations on SAP ERP applications, including financials, controlling, sales and distribution and materials management, supported by Oracle databases. Around 100 people regularly access the SAP applications.

With all its operations centralized, Parazelsus recognized the importance of high availability for its SAP applications and data, and ensuring rapid recovery if disaster struck. Ensuring these twin availability and disaster recovery goals was a major challenge for Parazelsus, with limited budget on hand.

Iqbal Syahrial, Senior IT Manager at Parazelsus, explains, “A major concern was our disaster recovery capabilities. We wanted to be able to ensure that the business would never have to face any short-term or long-term shut downs due to failure of its IT infrastructure.

“We wanted a system that could provide high availability and full disaster recovery at the lowest possible cost, based on a simple IT landscape that would be easy and cost-effective to operate.”

Choosing IBM Power servers and DB2
The Oracle database licenses were a significant expense for Parazelsus, and the company started the review process to look at other possible solutions. One option stood out: running SAP applications on IBM Power servers, supported by DB2. The license fee for DB2 database software was lower than the Oracle equivalent, and DB2 includes powerful high availability and disaster recovery (HADR) toolsets, which met Parazelsus’ immediate and future business objectives.

Iqbal Syahrial comments, “IBM DB2 provides HADR within the product, without any extra license fees or costs. This means that DB2 provides a lower total cost of ownership than any of its competitors, and the decision to move to IBM was actually made very easy for us.”

The next step was to consider the infrastructure platform. Iqbal Syahrial continues, “After careful consideration, and after studying competing solutions from other vendors, we decided to migrate to IBM Power servers for all our SAP ERP applications and DB2, and we are very happy with the results.”

Parazelsus implemented an IBM Power 550 server at its primary data center, with an IBM Power 520 server at a backup site. Both servers feature IBM POWER6 processors, and the servers run the IBM AIX operating system.

“In Indonesia, locally there are not many companies that know about SAP applications combined with IBM DB2. I think once they get to know it, they will be as amazed as we have been. It is both easy to integrate and easy to manage,” says Iqbal Syahrial.

“For example, we had set a target of migrating our systems to the IBM Power servers and DB2 over a two-month period. The training from IBM was excellent, and the transfer to DB2 proved to be very straightforward. We achieved the complete migration it in less than two weeks, and we probably could have done it even faster. This was an incredible turnaround time and we were very pleasantly surprised.”

The entire migration project was originally targeted to take six months. With assistance from IBM, from the first project preparation steps through blueprinting, implementation, final steps and go-live, Parazelsus completed the SAP application and DB2 migration in five months.

A key advantage for Parazelsus is the built-in high availability and disaster recovery (HADR) features of DB2. The HADR functionality protects against data loss by replicating data changes from the source database, called the primary, to a target database, called the standby. IBM DB2 HADR allows users to choose the level of protection from potential loss of data by specifying one of three synchronization modes: synchronous, near synchronous, or asynchronous, depending on the business need and the available hardware and network capabilities.

Quick and easy disaster recovery
Having completed the migration, the Parazelsus team wanted to test the DB2 recovery capabilities, as Iqbal Syahrial explains, “As soon as the migration was complete and the SAP applications were running, we tested the system in real-time. We shut down the primary server so that our clients were not able to access it and re-routed them to the disaster recovery standby server.

“Within a quarter of an hour we were up and running and it had become our primary server. We let people use the DR server for the whole day and then switched back to the primary in the evening. We then synchronized the servers and the next day our customers were back on the primary again. It was all very simple and smooth.”

Parazelsus used DB2 System Copy tools to replicate data from the primary to a standby SAP instance, which was then backed up offline. When the test was complete, Parazelsus restored the primary server and tested for accuracy. The complete process took less than one working day. In the future, the DB2 System Copy will replicate to the standby server, and the offline backup is retained for data security reasons.

“Many companies may have disaster recovery but they might be down for perhaps four or five hours before they can be up and running again. With DB2, we can recover in just 15 minutes from partial and complete site failures. This is a big advantage for us as we can ensure our business and sales are running at all times, and we can keep our customers happy, no matter what happens.”

For the SAP applications themselves, Iqbal Syahrial notes, “The shift to the new database was easy, and the administration of the SAP solutions is intuitive, using the DB2 Cockpit for SAP. The DB2 Cockpit makes things very simple, as we can manage our DB2 database, which is hosted at a datacenter almost two hours away, from within the SAP interface.”

Next steps
Parazelsus Indonesia is looking to continue its very high growth rates, which drives the need for an infrastructure that can scale up to meet demand in terms of both processing capacity and storage, and a database that can manage very large data volumes.

Iqbal Syahrial concludes, “The IBM Power servers and DB2 database both provide excellent scalability and can sustain our business requirements going forward. Overall we are very happy with the solutions that SAP and IBM have provided for Parazelsus Indonesia.”

Products and services used

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

Hardware:
Power 520 Express, Power 550 Express

Software:
DB2 for Linux, UNIX and Windows, AIX

Service:
IBM-SAP Alliance

Legal Information

IBM Deutschland GmbHD-70548 Stuttgartibm.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.