DBA Operations Monitor

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 (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).
• Check runs (for example, checking the database for critical situations)
• Configuration (for example, configuring database parameters)

Prerequisites

If a database operation does not fill the corresponding table(s) of the XDB interface or does not fill it (them) correctly, the DBA operations monitor will either display it (them) incorrectly or not at all.

Features

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

The initial screen displays a table containing the database operations.
The table includes the following columns:

Column	Meaning
Date	Date of the operation
Time	Start time of the operation
FID	Type of operation
Object	Database objects affected by the operation
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
RC	Operation result 0 means "Everything OK" 1 means "Warning" 2 to 9999 means "Error"
Runtime	Runtime of the operation
Program	Program that executes the operation (for example, SAPDBA)
Description	Short description of the operation

The initial screen also displays an overview of:

• Database operations already completed
• Database operations that are still running
• Current DBA operations monitor setup

Activities

Displaying specific database operations

To display specific database operations (for example, backup/recovery operations), choose the corresponding pushbutton, or the menu option under DBA operation. Choose Overview to display all DBA 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 ® Filter. Then choose either Warning message or Error. Choose the menu option All , to display all database operations. To set the time period for the view, choose Setup ® Filter ® Time period.

Update display

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

Automatically update display

To automatically refresh the display of database operations, choose Setup ® Auto Refresh ® Auto refresh ON. To deactivate automatic refresh of the display, choose Auto refresh OFF. To set the time interval for the refresh, choose Setup ® Auto Refresh ® Refresh interval.

Delete table entries

To delete database operations from the table, first select the relevant entries. Then choose Edit ® Delete, or Delete on the application toolbar.

Automatically delete table entries

To automatically delete table entries, choose Setup ® Auto Delete ® Auto delete ON. Choose Auto delete OFF to deactivate automatic delete. To set the time interval for the refresh, choose Setup ® Auto Delete ® Delete interval.

Sort table entries

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

Save setup

To save all your settings (filter, 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.