Janata Sahakari Bank Ltd., Pune

Realizes a 20 - 40 percent increase in database performance with DB2 upgrade

Published on 26-Jul-2012

Validated on 15 Jan 2014

"We’ve realized a 20 - 40 percent increase in database performance and 40 - 50 percent increase in DBA productivity with our latest DB2 upgrade." - Mr. Jitendra Ravetkar, IT Head, Janata Sahakari Bank Ltd., Pune

Customer:
Janata Sahakari Bank Ltd., Pune

Industry:
Banking

Deployment country:
India

IBM Business Partner:
Infrasoft Technologies Limited

Overview

As JSBL, Pune implemented its core banking system for online banking and related back office processes, performance and availability of the underlying infrastructure was critical as any outages or delays could be visible to customers and lead to customer dissatisfaction. Through its work with IBM Business Partner, Infrasoft Technologies, and use of IBM hardware, software and middleware, the bank reduced downtime by nearly 99.9 percent and can now deliver near real-time data for management information server reports.

Business need:
JSBL, Pune sought to implement a core banking system for online banking and related back office processes, such as fund transfers. Performance and availability of the underlying infrastructure was critical as any outages or delays could be visible to customers and lead to customer dissatisfaction.

Solution:
InfrasoftTech helped the bank implement its OMNIEnterprise core banking solution on an integrated, optimized platform from IBM, including hardware, software and middleware. The bank selected IBM DB2® over Oracle Database due to its exceptional performance and scalability, and lower licensing costs. DB2 HADR provided bank managers with near real-time data for MIS reports and reduced system downtime from 8 - 12 hours to less than 60 seconds.

Benefits:
Improved performance by 20 - 40 percent and increased DBA productivity by 40 - 50 percent with DB2 upgrade Provided near real-time data for MIS reports and reduced downtime by nearly 99.9 percent Reclaimed 15 - 20 percent of disk space with data compression

Case Study

Janata Sahakari Bank Ltd., Pune (JSBL, Pune) is a leading cooperative bank in the state of Maharashtra, India. Currently ranked fifth among cooperative banks in India, JSBL, Pune serves more than 10 million people.

The need
In 2005, JSBL, Pune sought to implement a core banking system for online banking and related back office processes, such as fund transfers. Performance and availability of the underlying infrastructure was critical as any outages or delays could be visible to customers and lead to customer dissatisfaction.

The solution
JSBL, Pune worked with IBM Business Partner, Infrasoft Technologies Limited (InfrasoftTech), to implement its OMNIEnterprise core banking solution on IBM DB2® database software. JSBL, Pune was among the first banks in India to implement DB2 on Linux, providing a successful model for core banking systems that many other Indian banks later followed. The bank selected IBM DB2 over Oracle Database for its database platform due to the exceptional performance and scalability, and lower licensing costs.

Since its initial deployment, the bank has upgraded its database to take advantage of the latest DB2 features. For example, the bank can now automatically replicate data changes from its source database to a standby database using the DB2 high availability disaster recovery (HADR) data replication and SQL replication features. This capability has helped the bank deliver 24x7 data availability and protect against unplanned disasters at a minimal cost. It also enabled IT staff to provide bank managers with near real-time data for management information server (MIS) reports. Previously, the bank’s MIS reports used banking data from the previous day’s backup, which meant that bank managers had to make business decisions based on day-old information.

The use of the DB2 HADR feature also helped reduce system downtime. Previously, the bank used manual database backup and restore processes, which, in some cases, resulted in 8 - 12 hours of downtime daily. Once DB2 HADR was implemented, this manual process was eliminated, and downtime became negligible—reduced to less than 60 seconds.

JSBL, Pune database administrators (DBAs) also found they were 40 - 50 percent more productive due to DB2 autonomic features, such as automatic memory tuning and maintenance. Today, DB2 database software supports approximately 500 GB of data and 50,000 transactions per day—a mix of online transaction processing (OLTP) and MIS queries.

For small and midsize banks, like JSBL, Pune, finding creative ways to lower operational costs is vital, and, here too, IBM has helped. Executives from JSBL, Pune and another cooperative bank in India sought to decrease IT costs by sharing resources. IBM helped the companies create an integrated, optimized and shared data center and disaster recovery site based on IBM Power Systems™ and IBM System Storage® technology. IBM Tivoli® System Automation software is used to automatically switch users, applications and data from one system to another in the cluster in the event of a failure. By combining IBM software, hardware and middleware, bank executives found they could cut costs while delivering the performance and availability required for such a visible customer-facing application.

The benefit

  • Improved performance by 20 - 40 percent with DB2 upgrade
  • Increased DBA productivity by 40 - 50 percent
  • Provided near real-time data for MIS reports and reduced downtime by nearly 99.9 percent

For more information
To learn more about IBM DB2, and IBM Systems and Technology, please contact your IBM representative or IBM Business Partner, or visit the following websites: ibm.com/software/db2 or ibm.com/systems

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 Workgroup Server Edition

Service:
Software Services for Information Management

Legal Information

© Copyright IBM Corporation 2012 IBM Corporation Software Group Route 100 Somers, NY 10589 Produced in the United States of America July 2012 IBM, the IBM logo, ibm.com, DB2, Power Systems, System Storage, and Tivoli are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at “Copyright and trademark information” at ibm.com/legal/copytrade.shtml Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. This document is current as of the initial date of publication and may be changed by IBM at any time. Not all offerings are available in every country in which IBM operates. The performance data and client examples cited are presented for illustrative purposes only. Actual performance results may vary depending on specific configurations and operating conditions. It is the user’s responsibility to evaluate and verify the operation of any other products or programs with IBM products and programs. THE INFORMATION IN THIS DOCUMENT IS PROVIDED “AS IS” WITHOUT ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF NON-INFRINGEMENT. IBM products are warranted according to the terms and conditions of the agreements under which they are provided. Actual available storage capacity may be reported for both uncompressed and compressed data and will vary and may be less than stated.