SAP on IBM Db2 for Linux, UNIX, and Windows

Find out how you can use the DBA Cockpit for database administration and monitoring tasks regarding performance, space, backup, configuration, diagnostics, and more.

View Documentation on SAP Help Portal

Blog Post: DBA Cockpit Enhancements for Db2 12.1 

Learn about security concepts and encryption for SAP on Db2: 

Role-Based Security Concept for Database Users on IBM Db2 for Linux, UNIX, and Windows

Running an SAP NetWeaver Application Server on Db2 for LUW with the IBM Db2 Encryption Technology

Secure Communication: Setting Up SSL/TLS Connections Between SAP Application Server ABAP and the Db2 Database 

Blog Post: Encrypting an SAP System on a Db2 for LUW Database - Reduce Downtime by Exploiting the HADR Feature

ALSM helps you avoid transaction log full situations and speed up rollback processing. To learn more, see the following blog posts and watch the video:

Advanced Log Space Management (ALSM) as of Db2 for LUW Version 11.5

Ad-Hoc Monitoring of Db2 Advanced Log Space Management (Part 1)

Using the DBA Cockpit for Monitoring ALSM

Video

Check out the following blog series to learn more about Fast Data Access:

Part 1: Why Fast Data Access (FDA) for ABAP “FOR ALL ENTRIES” Statements on IBM Db2 Is Useful

Part 2: How to detect and tune long-running Fast Data Access (FDA) statements

How to Benefit from Parallel INSERT for ABAP INSERT Statements on Column-Organized Tables

What’s the benefit of using transparent tables over cluster tables on Db2 for Linux, UNIX, and Windows? 

Read the blog post

Check out the following blog post about prefetching on the client side. To learn about the prefetching model on the database server side, read the IBM white paper.

Blog Post: New Query Block Prefetch Feature with Db2 11.5.6

IBM White Paper: Db2 Prefetching: Understanding, Configuring, Monitoring, Tuning