Database Administration Guide for SAP on IBM Db2 for Linux ...

1 Administration Guide | PUBLICD ocument Version: 2023-03-06 Database Administration Guide for SAP on IBM Db2 for Linux , UNIX, and Windows 2023 SAP SE or an SAP affiliate company. All rights BEST RUN Content1 Document Naming Administration Tools and Administration Administration Architectural SAP Application Server for SAP Application Server for Db2 Db2 Client User Management and SAP System Users and Authorizations for Db2 Directories and Database -Related Role-Based Security Concept for Database Roles for SAP System the Role-Based Security Database User Authentication Concept for AS Passwords ( )..31 Managing Passwords (Secure Storage).

2 32 Converting Password Storage in an SAP System to the Secure Storage in the File System .. User Authentication Concept for AS Other Security Features: SSL, Native Encryption, and Environment Db2 Profile Database Manager and Database Db2 Memory Important Database Memory Self-Tuning Memory Management (STMM)..45 Enabling Self-Tuning Memory Management (STMM)..477 Storage Administration Guide for SAP on IBM Db2 for Linux , UNIX, and Concepts of the SAP Schemas and the SAP System : CREATE Database the Size of the Tables and the Size of Tables and Tablespaces, Containers, and the File the Tablespace the Size of a the Size of a Tablespace the Available Space in a File Considerations About Compression in an SAP of Archived Log Range-Partitioned Insert Time Clustering (ITC) Column-Organized Tables (IBM Db2 With BLU Acceleration).

3 Converting Tables Using Report Dealing with Growing Diagnostic Backup and Enabling the Database for Rollforward Rollforward Recovery for a Single-Partition Rollforward Recovery for a Multi-Partition DB2 Log File of the Db2 Log File of the Db2 Log File File Log Manager Back-End Archived Log the Db2 Log Database a Database of of Backups and Required of Backup Backup Administration Guide for SAP on IBM Db2 for Linux , UNIX, and WindowsContentPUBLIC3 Monitoring Database Database Recovery Using the RECOVER Recovery Using the RESTORE and ROLLFORWARD File System Backups and db2inidb a File System a File System Backup for a File System Backup for Database a File System Backup to Set Up a Hot-Standby a File System Backup to Create a Db2 Backup Checking the Database for Copying an SAP System Using Db2 Redirected Building a Target System from a Split Relocating Database Database Locking Locking Locking Mechanisms in an SAP Monitoring Lock Activity and Lock Activity and Deadlocks Using the DBA Lock Activity and Deadlocks on the Db2 Command

4 Performance Monitoring Database Monitoring Dynamic SQL Updating Statistics for Database Statistics Using Automatic Reorganization of Database Automatic Monitoring Monitoring Network Monitoring I/O High Setup Types for High Cluster Management Installing Pacemaker with IBM Up a Standby Database Server Using Homogeneous System the HADR Pair .. SAP Adaptive Upgrading or Updating the Database to a Higher Version or Fix Pack Administration Guide for SAP on IBM Db2 for Linux , UNIX, and Updating the Db2 Fix Pack Rolling Update of the Db2 Fix Pack Update in a Db2 pureScale Update in a Db2 HADR Update of the Db2 Client Fix Pack Troubleshooting and Collecting Db2 Data and Identifying Basic Directory db2dump and Diagnostic Tools for Collecting and Analyzing Diagnostic Troubleshooting Using the DBA of Lock-Wait SQL Trace for SAP ABAP and Java Trace for SAP ABAP Systems (Transaction ST05).

5 169 SQL Trace for SAP Java Tracing the SAP Database Interface (DBSL)..170 What Is the DBSL?..170 DBSL Deadlock Db2 Trace Facility CLI SAP Graceful Maintenance Tool (GMT) for SAP Business Continuity During Database Micro-Outage Maintenance Tool (GMT).. brdb6brt Redirected Restore the brdb6brt Tool Command Line db6util - Tool to Assist Database Tool - Command Line the db6util db6level - Tool to Check Db2 Client db6_update_db Tool to Enable New Features After a Database Upgrade or Fix Pack db6_update_client - Script to Update the Client dscdb6up - Tool to Set and Update Administration Guide for SAP on IBM Db2 for Linux , UNIX, and rsecssfx - Tool to Create and Update Secure Storage in the File SAP-Specific User-Defined Functions and Stored Configuring Tivoli Storage Manager (TSM)

6 / IBM Spectrum Configuring TSM Files and Configuring TSM Environment Configuration Administration Guide for SAP on IBM Db2 for Linux , UNIX, and WindowsContent1 IntroductionThis Guide provides detailed information about the Administration of IBM Db2 for Linux , UNIX, and Windows in an SAP environment. It's primarily intended for Database administrators and SAP system administrators who need to plan, install, and maintain an SAP system on IBM Db2. A basic understanding of the fundamental Database concepts and an elementary knowledge of SAP system Administration are documentation applies to SAP systems based on SAP NetWeaver and higher on IBM Db2 , , , , and To avoid double naming, we mostly speak of "the Db2 Database " or just "Db2" when all IBM Db2 for Linux , UNIX, and Windows versions are addressed.

7 For more information, see our Naming Conventions [page 10]. NoteSAP systems running on IBM Db2 and lower are out of mainstream Administration Essentials Database Administration Guide for SAP on IBM Db2 for Linux , UNIX, and WindowsIntroductionPUBLIC7 Administration Tasks [page 13] User Management and Security [page 21] Configuration [page 37] Backup and Recovery [page 78] High Availability [page 147] Performance Considerations [page 136] Document History CautionMake sure you have the latest version of this document that you can find at on SAP Help following table provides an overview of the most important document changes:Document : SAP systems running on IBM Db2 and lower are out of mainstream update of Converting Password Storage in an SAP System to the Secure Storage in the File System [page 33] about secure storage in the file system (AS ABAP) was added (see User Authenti cation Concept for AS ABAP [page 30]).

8 Added: Fix Pack level check, new functions in the DBA Cockpit for EXPLAIN Updated: Links to IBM documentation Added: Link to blogpost about native Added: Information about the Pacemaker cluster software for high availability (see Cluster Management Software [page 151] and Installing Pacemaker with IBM Db2 [page 152]). Updated: Links to IBM updates and minor due to the release of Db2 MP4 Logspace Management (ALSM) was introduced. For more information about ALSM, see Components of the Db2 Log File Management [page 80]. due to new Db2 version Administration Guide for SAP on IBM Db2 for Linux , UNIX, and Db2 Mod 3 FP3 iFix001 SAP, there's a new default parameter setting for vendor log archive timeouts, see Configuration of the Db2 Log File Management [page 83] and Other Storage Vendors [page 90].

9 Sections Updating the Db2 Fix Pack Level [page 157] and Rolling Update of the Db2 Fix Pack Level [page 158] were Information about Db2 and removed because these Db2 versions are no longer supported as of 12-31-2017. Links to SAP Service Marketplace replaced by links to the new SAP Help Portal Graphics Change of Database name by IBM to IBM Db2 (formerly IBM DB2 for Linux , UNIX, and Windows), see Naming Conventions [page 10]. As of Db2 MP2 FP2:No more lock escalations due to new Db2 registry variable DB2_AVOID_LOCK_ESCALATION Information about Database partition groups was added to chapter Tablespaces, Contain ers, and the File System [page 54] of updates/corrections.

10 Configuring Tivoli Storage Manager (TSM) / IBM Spectrum Protect [page 220] (Renaming of IBM Tivoli Storage Manager to IBM Spectrum Protect) Checking the Database for Consistency [page 124] (new default setting of registry varia ble as of Db2 FP1) Some graphics were version due to new release of Db2 for Linux , UNIX, and Windows Version update with content and language correctionsFor example, the following sections were added or updated: Checking the Database for Consis tency [page 124], Locking Concepts [page 130], Locking Mechanisms in an SAP Environment [page 131], Db2 Memory Management Db2 Memory Management [page 42], Using Auto matic REORG [page 143], Self-Tuning Memory Management (STMM) [page 45], Redirected Restore [page 126], Updating Statistics Using Automatic RUNSTATS [page 140], and so Graceful Maintenance Tool (GMT) [page 189] was version has been enhanced with content referring to the newly released version of the Db2.