Using the DB Operations Monitor (SAP Library - Computing Center Management System (BC-CCM))

Using the DB Operations Monitor

Use

Use the DBA operations monitor for online monitoring of database operations within both internal and external database tools. You can also monitor runtime and remaining time of operations that are running. The DBA operations monitor can be used regardless of which database you are using. It provides historical as well as current (online) information about the following database operations:

Backup/Recovery (for example, to back up or recover the database)
Performance (for example, checking, creating, updating and deleting database statistics)
The memory structure (for example, space information for database objects, reorganization of database objects, or extending and deleting database objects).
Database checks (for example, checking the database for critical situations)
Configuration (for example, configuring database parameters)

Prerequisites

To use the database operations monitor, the tables of the XDB interface must be correctly filled.

Features

To call the DBA operations monitor, choose Tools ® CCMS ® DB administration ® Operations monitor Alternatively, call Transaction DB24.

In the group box Overview is an overview of the status of database operations that are running or have finished as well the current setup for the database operations monitor. The individual database operations are displayed in a table. The table includes the following columns:

Column	Meaning
RC	Result of the database operation: Green means "Everything OK" Yellow means "Warning" Red means "Error"
Status	Status of the operation: STARTED The operation started. However information about the operation is not yet available (for example, percent complete, or estimated remaining time). RUNNING The operation is running and information about the operation is available. COMPLETED The operation is finished
Date	Date of the operation
Time	Start time of the operation
FID	Type of operation
Object	Database objects that are affected by the operation or are key
Runtime	Runtime of the operation
Program	Program that executes the operation (for example, SAPDBA)
Description	Short description of the operation

Activities

Displaying specific database operations

To display specific database operations (for example, backup/recovery operations), choose the corresponding pushbutton, or the menu option under DB operation. Choose All database operations to display all DB operations.

Displaying specific views

To display specific views (for example, to display those database operations with status "warning", or those with status "error") choose Setup ® View. Then choose either Warning or Error. Choose All operations, to display all database operations. To set the time period for the view, choose Setup ® View ® Time period.

Updating display

To update the display of database operations, choose Edit ® Refresh, or choose Refresh on the application toolbar.

Automatically refresh display

To automatically refresh the display of database operations, choose Setup ® Auto-refresh ® Activate. To deactivate automatic refresh of the display, choose Deactivate. To set the time interval for the refresh, choose Setup ® Auto-Refresh ® Time Interval.

Deleting table entries

To delete database operations from the table, select the desired entries and choose Edit ® Delete.

Automatically deleting table entries

To automatically delete table entries, choose Setup ® Auto-delete ® Activate Choose Deactivate to deactivate automatic delete. To set the time interval for the refresh, choose Setup ® Auto-delete ® Time Interval.

Sorting table entries

To sort columns in ascending or descending order, first select the relevant column. Then choose Edit ® Sort and Descending, or Ascending. Alternately, choose Sort in descending order or Sort in ascending order on the application tool bar.

Printing table entries

To print table entries, choose Print

Saving settings

To save all your settings (view, auto-refresh, and auto-delete), choose Setup ® Save.

Details about database operations

For details about operations (for example, remaining time for the operation, or directory and name of the log file), double-click the table entry, or select the table entry and choose Display details on the application toolbar. On the next screen, choose Refresh on the application toolbar to update the display. Use Display action log to display a detailed log for the database operation.