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
● 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:
You reach the DBA Cockpit – which is mentioned several times in this section – by calling transaction DBACOCKPIT.
Task |
Function |
More Information |
Database start or stop |
Use the commands START DB2, STOP DB2 on the TSO panel. |
SAP DBA Guide: DB2 for z/OS |
Data recovery |
RESTORE SYSTEM utility |
SAP DBA Guide: DB2 for 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: DB2 for 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
|
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:
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 |
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 DB2 for z/OS Utility Guide.) |