You need to perform various tasks to administrate DB2 UDB 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.
If you are new to DB2 UDB for z/OS, see the following guides at:
service.sap.com/OperationsNW2004s
· SAP Database Administration Guide for SAP NetWeaver on IBM DB2 UDB for z/OS (SAP DBA Guide for DB2)
· SAP Planning Guide for SAP NetWeaver on IBM DB2 UDB for z/OS (SAP Planning Guide for DB2)
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 for DB2 |
Database failure with data loss |
DB13 |
SAP DBA Guide for DB2 |
Tablespace or data file management |
SE14 |
SAP DBA Guide for DB2 |
Table or index management |
· SE14 · SE11 |
SAP DBA Guide for DB2 |
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 for DB2: · 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 UDB 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 UDB for z/OS: Installation Guide |
The table below shows tasks that you need to perform periodically:
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.
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 UDB 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 UDB for z/OS Administration Guide.) |