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:
- Installation of SAP Systems based on the Application Server ABAP of SAP NetWeaver 7.1 to 7.52 on UNIX: IBM Db2 LUW
- Installation of SAP Systems based on the Application Server Java of SAP NetWeaver 7.1 to 7.5 on UNIX: IBM Db2 LUW
- SAP Note 1707361 - Inst. Systems based on NW 7.1 and Higher: UNIX Db2 for LUW
IBM Db2 and SAP NetWeaver on Windows:
- Installation of SAP Systems based on the Application Server ABAP of SAP NetWeaver 7.1 to 7.52 on Windows: IBM Db2 LUW
- Installation of SAP Systems based on the Application Server Java of SAP NetWeaver 7.1 to 7.5 on Windows: IBM Db2 LUW
- SAP Note 1707362 - Inst. Systems based on NW 7.1 and Higher: Windows Db2 LUW
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.