Database Administration for DB2 for z/OS

You need to perform various tasks to administer 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 product> Operations Database-Specific Guides

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:

Note Note

You reach the DBA Cockpit - which is mentioned several times in this section - by calling transaction DBACOCKPIT.

End of the note.

Task	Function	More Information
Database start or stop	Use the commands `START DB2`, `STOP DB2` on the TSO panel.	SAP DBA Guide : DB2for z/OS
Data recovery	`RESTORE SYSTEM` utility	SAP DBA Guide : DB2for z/OS Database Administration Backup Recovery
Tablespace or data file management	Transaction `SE14`	SAP DBA Guide: DB2 for z/OS
Table or index management	Transaction `SE14` Transaction `SE11`	SAP DBA Guide : DB2for z/OS
Improving performance	Use the DBA Cockpit to tune the following: DB2 Subsystem Activity Thread Activity Statement Cache 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 Statement Cache Global Times Data Set Statistics Installation Parameters
Access required to other systems, such as a BI source system	In the DBA Cockpit, choose ADD to add a system.	See Adding a Database Connection in the CCMS Documentation for IBM DB2 for z/OS.
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
System copy	You can use the SAP documentation with sample JCL jobs and SQL statements for a system copy.	System Copy for Services Based on <SAP version> <technology> IBM DB2 for z/OS Specific Procedures

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	DBA Cockpit Performance DB2 Parameter Check (DB16)
Run database backup	DBA Cockpit Job DBA Planning Calendar Action Pad Backup for all SAP tablespaces BACKUP SYSTEM utility which is described in SAP DBA Guide: DB2 for z/OS Database Administration Backup Online Backup
Monitor the DB2 for z/OS database	CCMS Monitor Set (transaction `RZ20`) and DBA Cockpit
Check the results of database administration tasks in the DBA Planning Calendar	DBA Cockpit
Run update statistics	DBA Cockpit
Reorg for space-saving and defragmentation	DBA Cockpit
DB2 Repair	(DB2 native tools. For more information, see the IBM DB2for z/OS Utility Guide.)