Administering the database of an SAP system is a key prerequisite for running an SAP installation without problems. SAP develops and delivers specific tools for SAP systems running on IBM Db2 that help database administrators with their tasks. Specific SAP products may need special considerations regarding database administration.
Table of Contents
(On the webpage on SAP Help Portal there's also a button to download the PDF version of this document.)
This guide explains in detail how you use Db2 in an SAP environment. The guide includes an architectural overview and outlines administration tasks in areas such as user management and security, configuration, memory management, storage management, backup and recovery, locking, and performance monitoring. The document is primarily intended for database administrators and SAP system administrators who need to install and maintain an SAP system on IBM Db2.
Database Administration Tools: DBA Cockpit
Read the DBA Cockpit Documentation
Database Administration Using the DBA Cockpit (SMP login required)
Use the above link to get to our documentation on how to administer and monitor your Db2 database in an SAP system landscape using the DBA Cockpit.
Watch our DBA Cockpit Videos
Demo: DBA Cockpit Overview
The DBA Cockpit is a tool designed for database administrators that work in an SAP environment. The demo gives you an overview of the most important functions of the DBA Cockpit, including performance monitoring, space administration, and database configuration.
As a database administrator, you need tools to analyze and solve performance issues. This software demo shows an example of how you can identify reasons for lock-waits using the time spent analysis in the DBA Cockpit.
In two 5-minute demos, you can see the new features for the DBA Cockpit that were created with support packages for SAP NetWeaver in 2012 and 2013. Highlights include more support for IBM Db2 for Linux, UNIX, and Windows version 10.1 and new screens for SAP GUI.
With SAP NetWeaver 7.02 SP 15 and higher, new SAP GUI screens for the DBA Cockpit are available. You can now use more metrics, drill-down capabilities, and graphics to analyze performance- and space-related issues in the SAP GUI version of the DBA Cockpit.
Watch this short demo about the new Network Statistics screen in the DBA Cockpit to find out how you can use it to analyze your network performance.
Insert time clustering (ITC) tables, a new table type introduced with Db2 10.1, allow for an easy and lightweight reclamation of free space. With Db2 10.5, an enhanced REORG operation for ITC tables can merge sparsely filled blocks of ITC tables to gain even more free space. This article examines the usage of ITC tables in a real-world SAP system.
Db2 10.1 offers new features that help to avoid reorganizations. This document discusses the usage of insert time clustering tables, index space reclamation and smart data and index prefetching in SAP systems running on Db2 10.1.
Most database systems offer specific "data organization schemes" that can be used to influence the physical representation of the table data on disk. IBM Db2 offers three such schemes: Database Partitioning (DPF), Multi-Dimensional Clustering (MDC) and - since Db2 9.1 - table partitioning. This article explains how you can apply table partitioning for tables in an SAP system.
This document describes how to set up a high-availability (HA) solution for IBM Db2 for Linux, UNIX and Windows using IBM Tivoli System Automation for Multiplatforms (SA MP) when your operating system is AIX or Linux.
Want to use the Db2 High Availability Disaster Recovery (HADR) feature to improve the availability of your SAP system? Check out this paper to learn how to automate Db2 HADR failover using IBM PowerHA/HACMP in a two-node cluster SAP environment.
Db2 Version 10.5 FP5 adds native database encryption support to the Db2 database server through the IBM Db2 Encryption Technology. In this paper, we will briefly describe how to enable IBM Db2 Encryption Technology on SAP systems and how to perform administrative tasks like database backup and restore in this environment.
SAP introduces a role-based security concept for database users on IBM Db2 V9.7 in SAP NetWeaver 7.0 or higher environments. With the role-based security concept, it is easier to create additional, individual administration users for all persons involved in monitoring and administration. The new security concept also helps to fine-tune access to remote databases from the SAP Solution Manager system.
The article describes how to encrypt the database of your SAP system with Windows Encrypting File System (EFS). It also provides performance data based on a test analysis that was done at the IBM SAP Integration and Support Centre.
Performance considerations of the DB2 for Linux, UNIX, and Windows stored procedure ADMIN_MOVE_TABLE (IBM developerWorks article)
This article describes performance considerations for the Db2 stored procedure ADMIN_MOVE_TABLE in an SAP system environment. We will examine tables with the characteristics of typical SAP systems.
More on Database Administration
DB2 Advanced Copy Services: The scripted interface (IBM developerWorks article)
This article describes how to use the scripted interface for Db2 Advanced Copy Services (Db2 ACS) that is available in Db2 10.5 and higher.
The IBM Knowledge Center is the central location for finding product information about all versions of Db2 for Linux, UNIX, and Windows.