IKB saves costs by migrating SAP databases

Row and index compression reduces storage requirements and boosts performance

Published on 09-May-2012

Validated on 07 Oct 2013

"The return on investment for the database migration project is less than one year. Saving costs in these difficult times is exactly what we were aiming for." - Holger Rosenberg, Director and Head of the SAP Competence Center, IKB Deutsche Industriebank AG

Customer:
IKB Deutsche Industriebank AG

Industry:
Banking

Deployment country:
Germany

Solution:
Business Resiliency, Enterprise Resource Planning, Information Integration, Linux, Optimizing IT

IBM Business Partner:
SAP

Overview

IKB Deutsche Industriebank is a specialist bank for corporate financing in Germany and Europe. Its target groups are small and medium-sized enterprises as well as international enterprises and private-equity funds.

Business need:
In the intensely competitive financial services sector, IKB Deutsche Industriebank AG, a specialist corporate finance bank in Germany, wanted to cut operational costs. With the introduction of new SAP applications, IKB looked at ways to improve system performance, reduce data storage space requirements and cut system administration expenses.

Solution:
Working with IBM®, IKB Deutsche Industriebank chose to migrate its SAP databases from Oracle to IBM DB2® for Linux, UNIX and Windows running on SUSE Linux Enterprise Server. After a successful proof of concept with the bank’s advanced SAP Bank Analyzer environment, all SAP systems at IKB Deutsche Industriebank were successfully migrated to IBM DB2.

Benefits:
Reduces operating costs for SAP and databases by 21 percent. Saves a total of 45 percent on storage space through reductions of database sizes by 60 percent with advanced row and index compression features. Improves database administration with system automation. Improves system performance as well as disaster recovery and backup times by about 50 percent.

Case Study

To read a German version of this case study, click here.

IKB Deutsche Industriebank is a specialist bank for corporate financing in Germany and Europe. Its target groups are small and medium-sized enterprises as well as international enterprises and private-equity funds.

To save costs on its SAP operations, the bank planned to migrate its SAP systems from the UNIX to the SUSE Linux Enterprise Server environment, running on standard Intel hardware. After upgrading its SAP applications to the latest releases, the bank also wanted to take advantage of new SAP features. However, the limitations of its existing database platform meant that such an undertaking would require significant additional investment.

Finding the best database for SAP
In line with its effort to save costs on hardware, IKB Deutsche Industriebank evaluated alternatives for its database software. Working with SAP, the bank assessed various database technologies and analysed the cost-efficiency of each solution. After comparing Oracle, Microsoft SQL Server and IBM DB2, IKB Deutsche Industriebank concluded that only IBM DB2 enabled the company to reduce its operating costs, improve system performance and save 45 percent on storage space. The close collaboration between IBM and SAP, with aligned product development cycles and close application integration, offered additional potential for simplified administration and further cost savings.

The bank selected its biggest and most complex SAP Bank Analyzer application with a database size of 2 TB for a proof of concept. When IBM had migrated and optimized the system, IKB Deutsche Industriebank’s SAP Bank Analyzer was running faster and the database size was reduced by approximately 50 percent thanks to IBM DB2.

Extensive SAP landscape
IKB Deutsche Industriebank operates 40 SAP landscapes, of which 11 are production systems serving 1,600 users. The bank’s SAP environment comprises the SAP ERP application, including modules for financials (FI) and controlling (CO) for its core financial processes, and SAP Bank Analyzer as its mission-critical application to comply with regulations, reporting and auditing requirements. The bank also uses SAP ERP Human Capital Management (HCM), SAP NetWeaver Business Warehouse (BW), SAP Supplier Relationship Management (SRM), SAP NetWeaver Portal and SAP E-Recruiting. The bank’s leasing subsidiary, IKB Leasing, additionally relies on SAP NetWeaver Application Server technology for a custom-developed leasing solution and the bank’s internal IT service provider, IKB Data, also uses SAP software to support its sales and distribution (SD) processes.

Migrating to IBM DB2
Working with SAP and IBM, IKB Deutsche Industriebank planned and managed the migration of all of its SAP systems from Oracle to IBM DB2 for Linux, UNIX and Windows on the bank’s new server infrastructure. The systems were migrated using the default heterogeneous system copy approach.

To migrate the 2 TB SAP Bank Analyzer database within the required timeframe, the standard migration method had to be optimized. Highly skilled IBM specialists analysed the databases to define the best migration sequence. The combined team migrated the two SAP systems using the table splitting method to enable parallel export and import operations to speed up the database migration.

“The IBM experts had previously migrated 16 TB systems before they arrived at our site, so our 2 TB database was not a big challenge for them,” notes Holger Rosenberg, Director and Head of the SAP Competence Center at IKB Deutsche Industriebank AG.

There were some pre-existing links between the Oracle databases and the bank’s credit-processing application. The IBM team replaced these with standardized links, enabling all applications to continue to function properly on the new database.

As part of the migration project, database administrators from IKB Deutsche Industriebank were invited to attend a four-day workshop on DB2 administration at IBM. “Even though IBM DB2 is easy to manage, the administration training we received from IBM was very valuable,” says Holger Rosenberg.

Saving costs with automation and compression
By deploying IBM DB2, IKB Deutsche Industriebank took advantage of many of its integrated autonomics features to automate system administration and optimization. These features enable the bank’s system administrators to spend less time with configuration and optimization without sacrificing performance.

The SAP DBA Cockpit for IBM DB2 offers improved integration of database management into SAP administration workflows, and provides more advanced and detailed insights into the configuration and status of the SAP database, making database management much more efficient.

The IBM DB2 row and index compression features improve memory exploitation, CPU utilization and also boost system performance, with reduced data traffic leading to faster system refreshes and quicker response times. Reduced total database sizes by 60 percent on average also lead to faster backup and recovery times, improving data protection and availability.

With the implementation of a new hardware platform running SUSE Linux Enterprise Server and the migration of its SAP databases to IBM DB2, IKB Deutsche Industriebank reduced the total investment costs for the new software and hardware infrastructure by 85 percent, cut the operating costs of its SAP environment by 21 percent and saved 80 percent in electricity costs. “The return on investment for the database migration project is less than one year,” says Holger Rosenberg. “Saving costs in these difficult times is exactly what we were aiming for.”

Holger Rosenberg concludes, “Whenever needed, IBM specialists were always available to help us out. We were looking for the best solution for IKB Deutsche Industriebank, and the service from the IBM consultants and the very good support confirms that we made the right decision to choose IBM DB2.”

Products and services used

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

Software:
DB2 for Linux, UNIX and Windows

Operating system:
Linux

Service:
IBM-SAP Alliance

Legal Information

© Copyright IBM Corporation 2012 IBM Deutschland GmbH 71137 Ehningen Deutschland ibm.com/de IBM Austria Obere Donaustrasse 95 1020 Wien ibm.com/at IBM Switzerland Vulkanstrasse 106 8010 Zürich ibm.com/ch Produced in Germany March 2012 IBM, the IBM logo, ibm.com and DB2 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. Other company, product or service names may be trademarks, or service marks of others. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. References in this publication to IBM products, programs or services do not imply that IBM intends to make these available in all countries in which IBM operates. Any reference to an IBM product, program or service is not intended to imply that only IBM’s product, program or service may be used. Any functionally equivalent product, program or service may be used instead. 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. IBM hardware products are manufactured from new parts, or new and used parts. In some cases, the hardware product may not be new and may have been previously installed. Regardless, IBM warranty terms apply. This publication is for general guidance only. Photographs may show design models.