We must schedule regular administrative jobs such as backups and database checks, and monitor the database regularly to minimize the downtime and improve the performance of SAP system. We can do these activities CCMS (Computer Center Management System) which provides the following transactions that help us to perform mentioned tasks.

DB12 (Backup Logs Overview). This transaction is used to view backup results, the status of the archive directory and a recovery report checking if all backups are available to perform a restore and recovery.

DB13 (DBA Planning Calendar) This transaction is used for scheduling backups and other administrative jobs in database system.

DB13C (DBA Planning Calendar Central) This transaction is used to schedule backups and administrative activities centrally for several SAP systems and databases.

DB14 (DBA Operations Monitor). This transaction is used for for checking the status and logs of all database operations, including backup monitoring, updates of the optimizer statistics, and database checks.

DB16 (Overview of Database Checks). This transaction is used to display different types of messages.

DB17 (Database Check Conditions). This transaction is used to view and maintain check conditions for the database system check

DB20 (Maintain Statistics). This transaction is used to maintain table statistics

DB21 (Maintain Statistics). This transaction is used for configuration of Statistics creation

DB26 (Database profile parameters). This transaction is used for displaying all database profile parameters overview with history

DB02 (Tables and Indexes Monitor). This transaction is used for monitoring of the storage behavior of the database (for example space statistics showing the history of the database, or size and free space in each tablespace) and the status of the database objects (for example size of each table in kilobytes and blocks, or indexes that are defined in the ABAP Dictionary but missing in the database).

ST04 (Database Performance Monitor). This transaction is used for displaying the most important indicators for Oracle database performance, such as buffer cache quality, statistics of user calls or number of block reads per SQL statement, and the configuration of the database management system and the database, either directly through showing current parameter values or with help of V$ views.

RZ20 (Database Alert Monitor). This transaction is used for monitoring all preset alerts for different areas of the database.

All of the above Transactions can be executed from the SAP Easy Access Menu as shown in the following figure.

SAP Database Monitors

This entry was posted on February 12, 2012 at 11:17 PM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in SAP Basis Notes by Raj No Comments Yet