SAP CCMS tools for 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, update statistics, and database checks)

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

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

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

Update Statistics (Transactions DB20 and DB21): Configure the cost-based optimizer, and check 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 DB26): 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

You can access the Overview screen by calling transaction DB6COCKPIT and choosing Backup and Recovery ? Backup Overview in the navigation frame of the DBA Cockpit.