Skip to main content

The IBM DB2 has become the database of choice for SAP implementations.

IBM and SAP have worked together for many years developing integrated and proven solutions that help customers realise immediate business value and sustainable business growth. The strength of this trusted partnership is illustrated by the fact that SAP is a major DB2 customer and IBM is a major SAP customer. Over the past two and a half years this partnership has been focussed on optimising the infrastructure benefits of DB2, with the first ‘optimised for SAP’ database released back in 2005.

Tab navigation


The close partnership between IBM and SAP has provided performance, scalability and cost advantages for both new and existing SAP customers. The DB2 database is now seen as the database of choice for SAP implementations and includes numerous industry-leading features which are all supported and recommended by SAP. Customers can enhance their data quality and reduce data errors with Information Server, reduce the size of their databases to improve their performance with ECM solutions and safeguard their data using storage and Tivoli solutions.

Manage your business, not your data server - Transforming data into actionable business information with DB2 9


The long-running and successful partnership between IBM and SAP enables you to benefit from technical superiority. DB2 is the database of choice for SAP implementations and contains many industry leading features that are all supported and recommended by SAP. Consider the key features of DB2 listed below:

Table compression

By compressing the data stored in your SAP systems you don’t just save space, you also improve the performance of your infrastructure. DB2 offers a unique compression system that is available for and supported by SAP immediately and can provide a significant impact on the cost of running your SAP system.

Multi-dimensional clustering (MDC)

MDC provides an elegant method for clustering data in tables along multiple dimensions in a flexible, continuous way. MDC, a unique DB2 feature, improves query performance on InfoCubes and DataStore objects as well as the performance of request-based operations. MDC can also significantly reduce the overheads of data management options such as reorganisation and index maintenance operations during insert, update and delete operations.

High availbality disaster recovery (HADR)

Protect your business data with the DB2 HADR feature. HADR provides customers with the reassurance that their database will not be a single point of failure within their SAP infrastructure. The database is monitored and switched automatically to either a local copy or to a remote disaster recovery site should a problem arise. HADR can also be used to enable maintenance to take place on your production environment whilst still maintaining availability.

Data partitioning

A database partition, sometimes called a node or database node, is a part of the database which consists of its own data, indexes, configuration files and transaction logs. Partitioned databases have two or more database partitions. Tables can be located in one or more database partitions, with some rows stored in one partition and some in another. When data is divided like this you can use the power of multiple processors to satisfy requests for information. Data retrieval and update requests are decomposed automatically into sub-requests and executed in parallel among the applicable database partitions. The split across partitions is not seen by users issuing SQL statements.


The SAP Application includes highly integrated tools that make both the application and database easier to manage. The interface has been written to allow SAP administrators to carry out many of the functions of a Database Administrator. This tighter integration, along with the database’s built-in Autonomic features reduces the time spent administering a DB2 for SAP environment. If you are migrating from another database this will also reduce the amount of training required and increase the speed with which the database staff become comfortable with the new system.


Many SAP customers have voiced discontent with the high cost and complexity associated with using the Oracle Database to power their SAP applications. And in May 2006, SAP announced that DB2 was now their preferred Data Server of choice. DB2 enables you to benefit from the ‘silent install’, SAP Tuner, On Demand storage and memory management and SQL access to DBA functions from the SAP applications.

Replacing your Oracle or Microsoft database with the better performing and feature-rich DB2 offering recommended by SAP themselves seems the obvious way to cut cost and complexity.

To find out more about using the IBM DB2 to power your SAP applications please call us on 01475 898688 or emailing us.

We’re here to help

Easy ways to get the answers you need.

Or call us at:
01475 898688

Required content plug-in