IBM Cloud Docs
AnyDB - IBM Db2

AnyDB - IBM Db2

The SAP systems in a landscape have specific requirements for servers, operating systems, network setup, and supported storage.

Deploying SAP AnyDB on IBM Cloud is similar to deployments with infrastructure with on-premises data centers. You can use the information that is provided from SAP and the RDBMS providers.

To assist your project's planning phase, more design considerations are provided for SAP AnyDB - IBM Db2 with IBM Cloud® for SAP.

Overview of IBM Db2 for SAP with IBM Cloud®

Several unique capabilities and features are available with IBM Db2. All supported database features that are mentioned in SAP Note 1555903 - DB6: Supported IBM Db2 Database Features are available with IBM Cloud, except for:

  • The IBM Db2 pureScale feature.
  • Support for integrated cluster managers for HADR or shared disk high-availability clusters.

Before you start deploying the IBM Db2 software, ensure that:

  • Check all relevant IBM Db2 information and prerequisites.
  • Check all relevant SAP and IBM Db2 information and prerequisites (for example, SAP Notes). Also, check the versions and fix pack levels of IBM Db2 that are supported.
  • All required packages are installed for the relevant OS that you are using for IBM Db2.

Documentation of IBM Db2 for SAP

A good place to start is the SAP community page for IBM Db2.

IBM Db2 support on SAP-certified Cloud IaaS:

IBM Db2 versions and fix pack levels that are supported by SAP:

IBM Db2 11.5 on UNIX/Linux prerequisites documentation:

IBM Db2 and SAP NetWeaver on UNIX/Linux:

IBM Db2 and SAP NetWeaver on Windows:

In the IBM Knowledge Center for Db2, the documentation links provided refer to specific pages on an IBM Db2 version. You can switch to the correct version by clicking the "Change version or product" in the upper left area of the IBM Knowledge Center.

SAP on IBM Db2 using Intel Bare Metal

See SAP Note 2414097 - SAP Applications on IBM Cloud Classic Infrastructure environment for supported IBM Db2 database versions.

A sample configuration is shown in:

SAP on IBM Db2 using Intel Virtual Servers

See SAP Note 2927211 - SAP Applications on IBM Cloud Virtual Private Cloud (VPC) Infrastructure environment for supported IBM Db2 database versions.

A sample configuration is shown in:

SAP on IBM Db2 using IBM Power Virtual Servers

This is a complementary offering from IBM Power Systems, with low latency access to IBM Cloud services

See SAP Note 2855850 - SAP Applications on IBM Power Virtual Servers for supported IBM Db2 database versions on AIX running on IBM Power Virtual Servers.

Infrastructure size considerations

When you use IBM Db2 with SAP applications, follow the general SAP sizing rules as described in the SAP Quick Sizer documentation. However, certain IBM Db2 functions require special considerations.

When you use IBM Db2 columnar organized tables, also known as IBM Db2 BLU Acceleration, the minimal recommended server configuration is 64 GB memory and 4 CPU cores exclusively available for the database workload. For more information about sizing and usage of Db2 BLU Acceleration, see SAP Note 1819734 - DB6: Use of BLU Acceleration.

File Systems for IBM Db2

The following information describes the File Systems that are required for IBM Db2 with SAP NetWeaver:

SWPM and IBM Db2 port conflict

The default port is 5912 for the TCP/IP communication between the Db2 server and the Db2 client when you are using SWPM to install SAP software.

However, this port is already defined and reserved by the IANA Service Name and Transport Protocol Port Number Registry.

Choose a different port during the installation with SWPM.

Alternatively, it is possible to remove the entry for this port number from the /etc/services file:

...
cpdlc           5911/sctp               # Controller Pilot Data Link Communication
fis             5912/tcp                # Flight Information Services
fis             5912/udp                # Flight Information Services
fis             5912/sctp               # Flight Information Services
ads-c           5913/tcp                # Automatic Dependent Surveillance
...

SAP application-specific considerations

SAP Business Warehouse with IBM Db2

When Using SAP Business Warehouse with the DB2 Database Partitioning Feature, a stable and fast network connections need to be established between all hosts in the Db2 DPF cluster. For details, check the following Information: SAP Business Warehouse on IBM Db2 for Linux, UNIX, and Windows 10.5 and Higher: Administration Tasks.