Procedure documentationOverview of SQL Locks Locate this document in the navigation structure

 

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

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose   Current Status   SQL Locks   Overview  .

or

Open the DBA Cockpit and choose   Performance   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.

More Information

DBA Cockpit: SAP MaxDB, Overview of SQL Locks