Dombivli Nagari Sahakari Bank Ltd.

Recovering from disasters and system failures in 10 seconds with no data loss

Published on 22-Nov-2011

Validated on 07 Oct 2013

" IBM DB2 on Power Systems has given us a more competitive position in the Indian banking industry by helping us reduce downtime from days to seconds." - Milind Varerkar, Deputy General Manager, Head of IT, Dombivli Nagari Sahakari Bank Ltd.

Customer:
Dombivli Nagari Sahakari Bank Ltd.

Industry:
Banking

Deployment country:
India

IBM Business Partner:
Infrasoft Technologies

Overview

Founded in 1970 and owned by approximately 60,000 shareholders, Dombivli Nagari Sahakari Bank Ltd. (DNS Bank) is a cooperative bank in Dombivli, India, a suburb of Mumbai.

Business need:
The bank wanted a cost-effective and proven disaster-recovery solution to keep its production database online, with negligible downtime during server or database outages. With a limited support staff of three, the bank also needed an easy-to-manage solution. 

Solution:
An integrated, optimized hardware, software and storage solution minimized downtime from planned activities and unplanned events, such as power outages. A two-node cluster automates switching of users, applications and data from one system to another in case of hardware or software failure. The DB2 HADR feature maintains availability of a secondary node in continuous replication with the primary node.

Benefits:
- 99.99 percent reduction in downtime from days to seconds - 30 to 35 percent savings from the cost of other vendors’ disaster recovery solutions - 25 to 30 percent of Fibre Channel disk space reclaimed with Deep Compression

Case Study

Founded in 1970 and owned by approximately 60,000 shareholders, Dombivli Nagari Sahakari Bank Ltd. (DNS Bank) is a cooperative bank in Dombivli, India, a suburb of Mumbai.

The need
DNS Bank has a front-office banking solution provided by IBM Business Partner Infrasoft Technologies which is used for generating business reports and managing bank branches. The solution provides applications for different financial services segments, with a common core back-office solution. To support this service, the bank’s back-office banking system needs the highest levels of reliability and availability. Any system outages required IT staff to retrieve data from tapes, and if the tapes had been sent to the offsite disaster recovery center, they had to be shipped back, further delaying recovery. The process could take one-to-two days. During these periods back-office operations were shut down, delaying customer facing operations, such as providing demand drafts or giving clients their transaction history, which could lead to customer dissatisfaction.

The bank used IBM® DB2® 8 data server with volumes of performance and transaction data in excess of 500 GB. It routinely performed 25,000 to 40,000 transactions per day, a mix of online transaction processing (OLTP) for internal clients and management information system (MIS) queries. In updating its environment, the bank sought to implement a disaster-recovery solution that would help it deliver online services to clients without interruption. With a limited support staff of three, the bank also needed an easy-to-manage solution.

The solution
When it came time to upgrade its database, the bank evaluated Oracle but, because of its positive experience with DB2, chose to upgrade to DB2 9.7 instead. IBM provided lower licensing, hardware, software and solution implementation costs and delivered an integrated, optimized solution that combined software, hardware and middleware. Additionally, local IBM Lab resources could provide rapid problem resolution.

The IBM India Software Lab (ISL) Services and Solutions team implemented IBM DB2 9.7 data server and used IBM Tivoli® System Automation software to maintain availability for a primary node cluster of two servers running the Red Hat Enterprise Linux operating system. The Tivoli System Automation software is actually owned by another cooperative bank. The other bank also worked on the same IBM solution with Infrasoft Technologies, and the two banks share the same data center, using each other’s resources. With the Tivoli software, DNS Bank automates the control of IT resources and activates automatic switching of users, applications and data from one system to another in the cluster in the event of a hardware or software failure.

The IBM team also configured the DB2 high availability disaster recovery (HADR) feature of the DB2 9 data server to maintain the availability of one secondary node server, also running the Red Hat Enterprise Linux operating system. The HADR server is at the disaster recovery center in synchronous replication with the primary node.

The HADR node runs on an IBM Power Systems™ server, which provides a reliable and available platform for continuous service. IBM System Storage® Fibre Channel disk arrays provide powerful disk storage for the primary and secondary production server.

The integrated solution of IBM DB2, IBM Power Systems and IBM System Storage minimized the downtime associated with many planned activities and many unplanned events, such as power outages. The redundant disaster recovery solution either eliminates downtime completely or reduces it to less than 10 seconds.

The other bank that is sharing the data center will also benefit from higher availability.

DNS Bank is also enjoying other benefits from the upgrade to DB2 9.7, such as Deep Compression. “IBM DB2 on Power Systems has given us a more competitive position in the Indian banking industry by helping us reduce downtime from days to seconds,” says Milind Varerkar, Deputy General Manager, Head of IT, Dombivli Nagari Sahakari Bank Ltd.

The benefit

  • 99.99 percent reduction in downtime from days to seconds
  • 30 to 35 percent savings from the cost of other vendors’ disaster recovery solutions
  • 25 to 30 percent of Fibre Channel disk space reclaimed with Deep Compression

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 website:
ibm.com/software/data/db2

Products and services used

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

Hardware:
Power Systems, Storage

Software:
Tivoli System Automation for Multiplatforms, DB2 for Linux, UNIX and Windows

Legal Information

© Copyright IBM Corporation 2011 IBM Corporation Software Group Route 100 Somers, NY 10589 U.S.A. Produced in the United States of America November 2011 All Rights Reserved IBM, the IBM logo, ibm.com, DB2, Power Systems, System Storage, and Tivoli are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Other company, product or service names may be trademarks or service marks of others. The information contained in this documentation is provided for informational purposes only. While efforts were made to verify the completeness and accuracy of the information contained in this documentation, it is provided “as is” without warranty of any kind, express or implied. In addition, this information is based on IBM’s current product plans and strategy, which are subject to change by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this documentation or any other documentation. Nothing contained in this documentation is intended to, nor shall have the effect of, creating any warranties or representations from IBM (or its suppliers or licensors), or altering the terms and conditions of the applicable license agreement governing the use of IBM software.