maxdb query the status of SQL locks from dbmcli

[Former Member]

Dear all,

I'm trying to find out how to have the status of SQL lock (exclusive and not) from command line with tools like dbmcli or sqlcli.

I did not find any suitable documentation on how to query this.

Any hint? regards

[thorsten_zielke · Accepted solution]

Hi,

this might not directly address your question, but if you are looking for detailed monitoring data, check the Database Analyzer log files. You can configure the Analyzer to collect data every 60 seconds. The Analyzer outputs to a text file 'dban.prt' warnings and info messages, plus there are many Excel files in the Analyzer subdirectory. This is best viewed within DB50/LC10 (and Database Studi should display this soon).

If you want to use dbmcli, you might check SAP FAQ note 1243937, section 19 regarding MaxDB locks and the internal system tables 'LOCKSTATISTICS', 'LOCKS', 'LOCK_HOLDER', 'LOCK_REQUESTOR', LOCK_WAITS'...

Thorsten