Find resources – including blogs, questions and answers, and resources for administering your Db2 for z/OS database with an SAP system.
Topic: Optimized Db2 maintenance in an SAP environment Time: June 18th, 4:00 p.m. CET (60 minutes) Speakers: Matthias Schneider (SAP), Bernd Kohler (SAP), Peter Becker (IBM)
Replay & Presentation
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
SAP on IBM Z solutions are often at the heart of large corporations, banks or insurances. In these environments, major requirements to the IT infrastructure are typically business continuity, security, automated operations, scalability and optimum support for integration tasks. Refer to the following documents on how to implement and run SAP on IBM Z to meet these needs:
SAP Business Suite on IBM ZSAP Banking on IBM ZSAP Insurance 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
IBM support of Db2 11 for z/OS is running out in September 2020; 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 completely revised version of the best practice guide “Migrating SAP Systems to Db2 12 for z/OS” is now available. The updated guide includes all the learning collected since Db2 12 for z/OS was released by SAP & IBM in October 2016. In addition, significant new information has been added in the following areas: system requirements, migration paths, online migration with Db2 data-sharing & maintenance with Db2 Continuous Delivery
Note 2303029Note 2302997Best Practice Guide Migrating SAP Systems to Db2 12Webcast (folder: Q4 -December12- 2019 RadioSAP: Migrating SAP to Db2 12 - revisited)
As a strategic solution, Db2 for z/OS provides the integrated BACKUP SYSTEM and RESTORE SYSTEM utilities. The 2017 edition of the Casebook for this solution to cover Db2 12 is available.
Casebook 2017 Edition