Database Administration for DB2 for z/OS

You need to perform various tasks to administrate DB2 for z/OS in an SAP environment. You may use SAP CCMS (which is part of the SAP standard delivery) to perform various administrative tasks.

We are aware that there is a wide variety of other tools that are available which you probably use to work with DB2. However, in this description we will concentrate on the tools available in SAP CCMS.

Getting Started

If you are new to DB2 for z/OS, see the following guides at:

http://service.sap.com/instguidesnw <Your SAP NetWeaver Release> Operations Database-Specific Guides

SAP Database Administration Guide for SAP NetWeaver on IBM DB2 for z/OS
SAP Planning Guide for SAP NetWeaver on IBM DB2 for z/OS

Tasks on Demand

The table below shows tasks that you need to perform when required:

Reason	Task	More Information
Database start or stop	Use the commands `START DB2`, `STOP DB2` on the TSO panel.	SAP Database Administration Guide: DB2 for z/OS
Database failure with data loss	DB13	SAP Database Administration Guide: DB2 for z/OS
Tablespace or data file management	SE14	SAP Database Administration Guide: DB2 for z/OS
Table or index management	SE14 SE11	SAP Database Administration Guide: DB2 for z/OS
Performance problem	Use transaction ST04 to tune the following: DB2 Subsystem Activity Thread Activity Cached Statements Statistics Global Times Data Set Statistics Installation Parameters	See the following sections in the SAP Database Administration Guide: DB2 for z/OS: DB2 Subsystem Activity Thread Activity Cached Statements Statistics Global Times Data Set Statistics Installation Parameters
Access required to other systems, such as a BW source system	Multiconnect with `DDF`	IBM DB2 for z/OS: Installation Guide
Database version maintenance	Apply PTFs, ++APARs, USERMODs Migrate to higher DB2 version	For PTFs: IBM SMP/E Guide For PTF Check: SAP report `RSDB2FIX` For all other tasks, see IBM DB2 for z/OS:Installation Guide

Periodic Tasks

The following tasks need to be performed periodically:

Run database system check

Run database backup

Monitor the DB2 for z/OS database

Check the results of database administration tasks in the DBA Planning Calendar

Run update statistics

Reorg for space-saving and defragmentation

DB2 Backup

DB2 Repair

Homogeneous System Copy

Whenever possible, use the DBA Planning Calendar for these tasks. You can choose from a range of predefined action patterns that include the tasks listed here.