SAP/DB2 Universal Database DBA in CCMS (SAP Library - Computing Center Management System (BC-CCM))

SAP/DB2 Universal Database DBA in CCMS

Purpose

This component enables you to manage your DB2 Universal Database using the Computing Center Management System (CCMS). With CCMS, you get extensive support for database administration (DBA) for the DB2 Universal Database and can perform many DBA functions from within the R/3 System.

Integration

You can perform most regularly-recurring database administration tasks from within the R/3 System by using the DBA tools of the CCMS.

Area of Administration:	Can Be Performed Using:
Installation	Operating system
Data backup Back up database files, archive logs	R/3 (CCMS), operating system, SAP-DB2admin
Performance tuning Analyze database performance data	R/3 (CCMS), operating system, SAP-DB2admin
Optimizer management Update optimizer statistics	R/3 (CCMS), operating system, SAP-DB2admin
Monitoring Track the database with the alert monitor, check database	R/3 (CCMS)
Database check Space analysis (number of objects, fragmentation, bottlenecks), configuration check (log directory, DB(M) parameters)	R/3 (CCMS), SAP-DB2admin
Tables/Indexes Analyze tables and indexes	R/3 (CCMS)
Reorganization	R/3 (CCMS)
Other (Recovery)	Operating system, SAP-DB2admin

Features

The main DBA features for DB2 Universal Database in CCMS are:

Area of Administration	Can Be Performed in CCMS Using:
Scheduling archive, backup, update statistics, and other tasks	DBA Planning Calendar
Update statistics	Update Statistics
Performance tuning and monitoring	Database Monitor and Database Alert Monitor
Checking backup results	Backup Logs and Database Alert Monitor
System checks (that is, configuration and performance)	Database Alert Monitor
Disk space check	Database Alert Monitor

Constraints

You have to perform certain DBA functions outside the R/3 System.