SAP/Oracle DBA in CCMS (SAP Library - Computing Center Management System (BC-CCM))

SAP/Oracle DBA in CCMS

Database Administration Tasks Supported by the CCMS

You can perform most regularly-recurring database administration tasks from within the R/3 System by using the DBA tools of the CCMS. As the table below shows, after installation, reorganizations and certain other tasks are the only tasks that cannot be carried out from within R/3.

Database Task:	Executed using:
Installation	Operating system
Data backup Backup database files and redo log files	R/3 (CCMS), operating system (SAPDBA)
Performance optimizing Monitor and optimize database performance	R/3 (CCMS), operating system (SAPDBA)
Access optimizing Configure cost-based optimizer, create and update statistics	R/3 (CCMS), operating system (SAPDBA)
Monitoring Monitor database using alert monitor, check database and SAPDBA action logs	R/3 (CCMS), operating system (SAPDBA)
Check Analyze space (number of objects, fragmentation, bottlenecks), check configuration (control file, online redo log files, INIT.ORA parameters)	R/3 (CCMS), (SAPDBA)
Reorganization Reorganize database	Operating system (SAPDBA)
Other tasks For example, database recovery (restore/recovery)	Operating system (SAPDBA)

CCMS Database Administration

The main CCMS tools for database administration are:

Displaying Backup Logs and Status (Transaction DB12): Check the status of database backups

The DBA Planning Calendar (Transaction DB13): Automatically schedule and execute database operations (for example, database backups and analyses)

Displaying SAPDBA Logs (Transaction DB14): Access action logs created by SAPDBA, BRBACKUP, BRARCHIVE, BRRESTORE or an external program

The Data Archiving administration tool (Transaction DB15): Systematic display function for managing archived R/3 data

The Database System Check (Transactions DB16 and DB17): Check important database parameters to be able to recognize critical database situations in time.

The Cost-based Optimizer administration tool (Transactions DB20 and DB21) Configure the cost-based optimizer, and create and update optimizer statistics

The DB Operations Monitor (Transaction DB24): Online monitoring of database operations (for example, data backups, database checks, and so on)

Online Maintenance of Database Parameters (Transaction DB27): Details and history of parameters

Maintaining Database Connection Information (Transaction DBCO): Information about additional, non-standard database connections

The Database Performance Monitor (Transaction ST04): Detailed database performance information and histories

For more information, see BC SAP Database Administration: ORACLE

The SAPDBA program is a tool for administering the R/3 database (Oracle) and is implemented outside the R/3 System. Use SAPDBA for all database administration tasks, even for those tasks that cannot be administered in the R/3 System using the CCMS (for example, reorganization).