Using the Native DB Monitors

Use

The Native DB monitors function is a collection of database-dependent monitors for monitoring underlying databases directly. The function supports all RDMBSs that are allowed as primary databases for the AS Java.

The Native DB Monitors function consists of the following monitors:

Database Activity

Shows a database-dependent view of the current database activity. The displayed columns are different depending on the RDBMS.

Caution

Refreshing the list may take longer on databases with a high number of parallel sessions.
Current Exclusive Lock Wait Situations

Shows processes currently holding or waiting for locks.
Note
- The Current Exclusive Lock Wait Situations on Database table is generally the same for all supported databases. However, the column content can have different meanings depending on the RDBMS.
- You cannot sort or filter the Current Exclusive Lock Wait Situations on Database table.

Prerequisites

You are in Start of the navigation path Troubleshooting Next navigation step Database Open SQL Monitors Native DB Monitors End of the navigation path function of SAP NetWeaver Administrator.

Procedure

To view database activity for a DataSource on a underlying database, select a DataSource in the Native SQL and Open SQL Datasources screen area, and choose Show DB Activity . The Current Database Activity area opens.
To view lock situations, select a DataSource in the Native SQL and Open SQL Datasources screen area, and choose Show Current Exclusive Lock Wait Situations . The Current Exclusive Lock Wait Situations on Database area opens. Normally, exclusive lock situations do not last long and thus it is normal (and desired) for the table to be empty.