SQL Locks Overview 

In the SQL Locks user menu, you can find a display of the SQL locks and SQL lock requests.

Prerequisites

The user has been assigned a role in accordance with the authorization concept.

You are in the user menu of the user with the authorizations that correspond to this role.

The liveCache database instance is in the ONLINE operational state.

Procedure

...

       1.      In the user menu, choose liveCache Assistant(transaction LC10).

       2.      Enter the name of the database connection.
You can select the name from the list of existing names. You can restrict the search for the required name.

       3.      Choose liveCache → Monitoring.

       4.      Choose Problem Analysis → SQL Locks → Overview.

Result

The system displays detailed information about the locks currently set. This display can be very long in a running SAP system. Therefore, you should always enter the analysis of SQL locks through the overview of wait situations.