Find resources – including blogs, questions and answers, and resources for administering your Db2 for z/OS database with an SAP system.
New versions of the SAP on IBM Z Reference Architectures are available. Download the PDFs and get the latest updates about SAP's maintenance strategy until 2030, the tight integration of ABAP & cloud services and various technology enhancements (e.g. IBM z15, DS8900F, IBM Z System Recovery Boost & SAP Cloud Platform).
SAP Business Suite on IBM ZSAP Banking on IBM ZSAP Insurance on IBM Z
Topic: Connectivity of SAP to Db2 for z/OS Time: December 10th, 4:00 p.m. CET (60 minutes) Speakers: Matthias Gimbel (SAP), Peter Becker (IBM), Nicolas Nardelli (IBM), Volker Schölles (IBM)
Replay
SAP has successfully finished the certification of SAP application servers with Windows 2019, SLES 15 and RHEL 8 in combination with Db2 for z/OS. Please note that the new OS versions require Db2 Connect 11.5. More details are available in SAP Note 2919991.
SAP Note 2919991
This edition is based on IBM System Automation for z/OS 4.1 with APAR level OA54684 and on IBM System Automation for z/OS 4.2 with APAR level OA58750. It includes support of Red Hat Enterprise Linux for IBM Power System Big Endian and Little Endian as application server platform and new System Automation 4.1 functions (suspend and resume).
Business Continuity for SAP on IBM Z, Edition 2020
On z/OS the CPU consumption of Solution Manager Diagnostics (SMD) Agents can be very high if there are many (real and virtual) network interfaces. This is because there is one agent (Java process) for each network interface. A detailed study revealed that a huge part of the CPU utilization is triggered by explicit garbage collection calls which are superfluous with today's Java Virtual Machines. Fortunately, these calls can be deactivated without any code change by a simple adjustment of the SMD Agents' profile.
Note 2998723 - SMD Agent on z/OS: up to 80% CPU reduction by deactivating garbage collection
The increase of external and insider threats and regulatory requirements now compel enterprises to implement more secure technologies. One of the most important is using encrypted digital certificates with the Transport Layer Security (TLS) protocol (formerly known as Secure Sockets Layers - SSL) as an addition to or a full replacement for user and password credentials. Details on how to set this up in an SAP on IBM Z environment are provided in the following best practice document:
TLS Certificate Authentication for SAP Application Server Connections to Db2 on IBM Z
IBM support of Db2 11 for z/OS has been extended to March 2021. Nevertheless, it is high time that you start moving your SAP landscape on IBM Z to Db2 12 for z/OS if you have not yet done so. A revised version of the best practice guide “Migrating SAP Systems to Db2 12 for z/OS” is available since 18Sep2020 with updates in the following areas: Handling of APPLCOMPAT level, Online/offline Db2 12 migration procedure (ABAP & J2EE stack) & Online/offline BIND/REBIND of Db2 Connect packages (CLI & JDBC)
Best Practice Guide Migrating SAP Systems to Db2 12Webcast (folder: Q4 -December12- 2019 RadioSAP: Migrating SAP to Db2 12 - revisited)Note 2302997 - Release of Db2 12 for SAP ComponentsNote 2303029 - Migration to DB2 12Note 2902423 - Support of APPLCOMPAT=V12R1M506
IBM's current Z processor family supports enhanced data compression using Huffman encoding. The SAP on IBM Z performance team located in Poughkeepsie just finished a first study using banking workloads to assess the effects of the new technology on disk space, performance and throughput.
Performance Evaluation of Huffman Compression with SAP Banking on IBM Z
SAP has successfully certified the usage of APPLCOMPAT=V12R1M506. For the time being the following SQL features are exploited: LISTAGG built-in function (FL501), explicit casting of numeric values to GRAPHIC or VARGRAPHIC (FL502) & implicit drop of explicitly created database objects (FL506). Raising APPLCOMPAT to V12R1M506 is optional for customers. SAP applications will always check the APPLCOMPAT level before using any new SQL features.
SAP Note 2902423Db2 12 Function Levels