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 OperationsNW70

SAP Database Administration Guide for SAP NetWeaver on IBM DB2 for z/OS
(SAP DBA Guide: DB2 for z/OS)
SAP Planning Guide for SAP NetWeaver on IBM DB2 for z/OS
(SAP Planning Guide: 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 DBA Guide: DB2 for z/OS
Database failure with data loss	DB13	SAP DBA Guide: DB2 for z/OS
Tablespace or data file management	SE14	SAP DBA Guide: DB2 for z/OS
Table or index management	SE14 SE11	SAP DBA 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 DBA 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 table below shows tasks that you need to perform periodically:

Example Example

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.

End of the example.

Task	Recommended Tool
Run database system check	DB System Check (transaction DB16)
Run database backup	DBA Planning Calendar (transaction DB13)
Monitor the DB2 for z/OS database	CCMS Monitor Set (transaction RZ20)
Check the results of database administration tasks in the DBA Planning Calendar	DBA Planning Calendar (transaction DB13)
Run update statistics	DBA Planning Calendar (transaction DB13)
Reorg for space-saving and defragmentation	DBA Planning Calendar (transaction DB13)
DB2 Backup	DBA Planning Calendar (transaction DB13)
DB2 Repair	(DB2 native tools. For more information, see the IBM DB2 for z/OS Utility Guide.)
Recalculate DB2 catalog sizes	Extent Monitor (transaction DB02) in conjunction with `REORG` in DBA Planning Calendar (transaction DB13)
Homogeneous System Copy	(DB2 native tools. For more information, see the IBM DB2 for z/OS Administration Guide.)