In the SQL Locks user menu, you can find a display of the SQL locks and SQL lock requests.
Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose .
The SQL locks display is part of the DBA Cockpit and can therefore also be called as follows:
Open DBA Cockpit (transaction DBACOCKPIT).
The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using.
Choose
.SAP NetWeaver 7.1: Choose .
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.
DBA Cockpit:SAP MaxDB, SQL Locks Overview