Published on 26-Dec-2012
"DB2 10’s back-out capability allows us to take some of our routine processes, which used to require a time-consuming forward recovery, and just back out changes instead, so we’re saving time and improving availability." - Michael Shaul, database administration team leader, Bank Hapoalim
System z Software
Bank Hapoalim is one of the largest in Israel. It services corporate and retail customers and has a significant international presence, with branches, subsidiaries and representative offices in North America, Latin America, Europe, East Asia, Turkey and Australia.
Bank Hapoalim needed to ensure that its IT infrastructure could continue supporting its range of industry leading services.
The bank implemented IBM DB2 10 for z/OS data server software to add efficiency and productivity to its application structure.
Bank Hapoalim upgraded its workload management and data storage capability, reducing tape usage by approximately 25 percent.
Founded in 1921, Bank Hapoalim is Israel’s leading financial services group and one of its largest banks. It services corporate and retail customers and has a significant international presence, with branches, subsidiaries and representative offices in North America, Latin America, Europe, East Asia, Turkey and Australia.
Bank Hapoalim prides itself on an innovative approach to banking, and the performance of its underlying IT infrastructure is critical to delivering on that strategy. Keeping pace with the bank’s ongoing and accelerating drive for business innovation requires a continuous focus on optimizing workload, memory and storage management. It also means ensuring that the bank’s database management system provides the necessary scalability, reliability and security.
The linchpin of this drive for continuous improvement is the bank’s IBM® DB2® for z/OS® data server software, which it upgrades with every new version. During the execution of its latest upgrade to IBM DB2 10 for z/OS data server software, the bank needed to minimize business interruptions.
Bank Hapoalim is a longtime DB2 for z/OS data server software user, having adopted the technology in the 1980s. Since then, it has been on the forefront of exploiting the new functionality offered in each subsequent release.
“We began planning for our DB2 9 to DB2 10 upgrade project very shortly after the new release went into general availability,” says Michael Shaul, database administration team leader for Bank Hapoalim. “The actual upgrade process went very smoothly; I would say it was our easiest yet.”
Easing the process was the DB2 for z/OS solution’s highly scalable data-sharing environment, which makes the already highly available
IBM mainframe running the z/OS operating system even more available by clustering it in a shared-disk configuration. For the first time, Bank Hapoalim was able to keep part of its DB2 data server software workload active during the upgrade, minimizing the impact on the work. “We were able to upgrade one member at a time and keep our online workload running throughout the process with minimal disruption,” says Michael.
Many businesses can make a strong case for a DB2 10 for z/OS data server software upgrade solely because of the potential CPU savings. Workloads at Bank Hapoalim, however, are predominantly COBOL using highly optimized and strictly controlled static SQL, so Michael was not expecting significant reductions. Nonetheless, the bank measured a CPU savings of around 3 percent in some batch workloads, while using 1MB page frames.
The impact on tape usage, however, has been considerable. With the DB2 10 for z/OS data server software upgrade, system management facilities volumes are down by around 75 percent, which translates to an approximate 25 percent tape usage savings. Additionally, according to Michael, DB2 10 for z/OS data server software contributes to process optimization. “DB2 10’s back-out capability allows us to take some of our routine processes, which used to require a time-consuming forward recovery, and just back out changes instead, so we’re saving time and improving availability.”
True to history, Michael points to one more benefit of his company’s upgrade to DB2 10 for z/OS data server software. “It’s a prerequisite for the next release of DB2, and we’re already looking forward to some of the new features and functions that are likely to be delivered.”
• Lowers system management facilities volumes by approximately 75 percent
• Reduces tape usage by around 25 percent• Decreases CPU requirements for some batch workloads
For more information
To learn more about IBM System z software, please contact your IBM representative or IBM Business Partner, or visit the following website, ibm.com/software/systemz.
Products and services used
IBM products and services that were used in this case study.
DB2 for z/OS
© Copyright IBM Corporation 2012 IBM Corporation Software Group Route 100 Somers, NY 10589 Produced in the United States of America January 2012 IBM, the IBM logo, ibm.com, System z, DB2 and z/OS 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 www.ibm.com/legal/copytrade.shtml. 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 discussed herein is presented as derived under specific operating conditions. Actual results may vary. 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. The client is responsible for ensuring compliance with laws and regulations applicable to it. IBM does not provide legal advice or represent or warrant that its services or products will ensure that the client is in compliance with any law or regulation. Statements regarding IBM’s future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.