Using the DB Operations Monitor 

Use

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

·        Backup or recovery (for example, to back up or recover the database)

·        Performance (for example, checking, creating, and updating database statistics)

·        Database checks (for example, checking the database for critical situations)

·        Configuration (for example, configuring database parameters)

SAP no longer supports this tool. Therefore, we recommend that you no longer use it.

Prerequisites

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

Activities

Call TransactionDB24.

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 "Success" 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 HANDLED Operation ended with a return code not equal to 0 and the problem was fixed.
Date	Date of the operation
Time	Start time of the operation
FID	Type of operation
Object	Database objects that are affected by the operation
Runtime	Runtime of the operation
Program	Program that executes the operation (for example, Database manager or BRBACKUP)
Description	Short description of the operation

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. If a detailed log for the database operation is available, choose Action log to display it.