Published on 05-Dec-2013
"We are very pleased with the results of the Extended LRSN feature - it works well and definitely addresses our pain points. The bank is very satisfied from both the ease of use and the test results." - Spokesperson, EMEA bank
An EMEA bank
High Availability , Information Management Foundation, System z Software, Virtualization, Virtualization - Server
The bank is one of the leading financial services groups in its country, serving both corporate and retail customers. It also has a significant international presence.
Known technical limitations at this bank in EMEA threatened the bank’s data capabilities. The company needed to resolve these limitations in order to continue its information-based innovation strategy.
The bank joined the Early Support Program for IBM® DB2® 11 for z/OS®, enabling immediate testing of the Extended Log Record Sequence Number (LRSN) functionality.
The bank is able to demonstrate that Extended Log Record Sequence Number and many other scalability and performance enhancements will enable the bank’s long-term growth plans.
This case study describes how a bank in the EMEA worked with IBM in its Early Support Program for IBM DB2 11 for z/OS. The bank is one of the leading financial services groups in its country, serving both corporate and retail customers. It also has a significant international presence.
Innovation that relies on IBM DB2
The bank prides itself on an innovative approach to banking, and the performance of its underlying IT infrastructure is critical to success. 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. The bank joined the Early Support Program for DB2 11 for z/OS data server software, keen to take advantage of the newest functionality.
The bank 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.
Establishing the business advantages of DB2
The bank’s focus was to establish experience of the new features in DB2 11, and assess the additional business value that the advanced functionality offers.
Known technical limitations threatened the bank’s data capabilities, which had to be resolved if the bank was to continue its information-based innovation strategy. The bank faced a hard-stop on operations, and it was critical that a solution be tested and deployed in good time. The company wanted to examine the Extended Log Record Sequence Number (Extended LRSN) feature, which introduces ten-byte log addresses.
A spokesperson for the bank comments, “We wanted to make sure that Extended LRSN will give us the solution that we need, to test it ourselves and see that it is ready, and to get familiar with the conversion process. In addition, we wanted to make sure that the tools from IBM and ISVs work properly with Extended LRSN.
“Extended LRSN not only resolves a technical issue but also has a positive business impact by significantly improving performance, enhancing efficiency and reducing costs This makes it a valuable DB2 11 feature for us. We are very pleased with the results of the Extended LRSN feature - it works well and definitely addresses our pain points. The bank is very satisfied from both the ease of use and the test results.
“Though we have so far focused on Extended LRSN, we were also impressed with the code quality of DB2 11, which offers very reliable operations. The next phase is to test IBM Optim™ Query Capture & Replay while running a full workload in the background. Based on our latest experience with DB2 11, we are expecting very good outcomes.”
Save money, save time, reduce costs with DB2
The bank operates two IBM zEnterprise® 196 servers in a Parallel Sysplex®, running z/OS. The bank runs a total of 18 DB2 instances, for sandbox, test, pre-production and production. For the DB2 11 project, the bank runs virtual servers using IBM z/VM®, replicating typical batch, IBM CICS®, data staging and event publishing processes.
The advanced functionality of DB2 11 for z/OS is designed to help save money, save time, and reduce costs by providing very high availability, reliability, and security for business-critical information. Embedded and enhanced analytics for business growth assist with accelerated business insight, and new tools offer simpler, faster migration that help achieve even greater return on investment.
DB2 11 for z/OS includes specific improvements that will help to reduce CPU and performance improvements for certain online transaction processing (OLTP), heavy insert, select query workloads, and when running queries against compressed tables. The improved data-sharing performance and efficiency combined with sharper utility performance and additional zIIP eligible workload will help to boost productivity and reduce costs. Finally, a wealth of additional enhancements will help enable DBAs, application developers, and system administrators to move to higher-value, more productive tasks.
The spokesperson concludes, “The overall experience of the DB2 11 Early Support Program is amazing. Working closely with IBM is great, and I would definitely recommend participating in future ESPs to management and other customers.”
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
© Copyright IBM Corporation 2013. IBM Corporation. Systems and Technology Group. Route 100. Somers, NY 10589. Produced in the United States. November 2013. IBM, the IBM logo, ibm.com, DB2, InfoSphere, Optim, Parallel Sysplex, z/Enterprise, z/OS and z/VM 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 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 client examples cited are presented for illustrative purposes only. Actual performance results may vary depending on specific configurations and operating conditions. 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.