Table for Lock Objects - SM12

[Former Member]

Hi,

I want to know the table that holds the LOCK OBJECTS that are created. Or any explanation, where lock objects are stored and can be monitored. Recently, there were over 2,000 lock ojects got created which made the our R/3 (4.7) system. What is the best way to monitor this besides SM12.

Thanks

[Former Member · Accepted solution]

I don't think that the lock data is stored in some database table, it is held in shared memory at runtime as long as the application server is running. But if you want to automate the monitoring, I am not sure if SAP provides a ready-made solution for that, but you can definitely create a customn ABAP program where you can use the FM provided by SAP to read the lock data and the based on your requirements send an external email to a list of user of the total locks exceeds a particular limit.

[Former Member · Accepted solution]

HI Satinder,

Do you know what FM is that?

thanks

[Former Member · Accepted solution]

Hello Naved,

I would also like to think that the lock table is something that exists in the shared memory of the application servers , rahter than in the ABAP dictionary.

However, I have the following pointers which I hope you will find useful -

1. Go to this link in the SAP Documentation. It contains the detailed and easy-to-understand explanation of the SAP Lock Concept. It also tells you why some of the most common problems with locks occur and how they can be tackled.

http://help.sap.com/saphelp_erp2004/helpdata/en/37/a2e3ae344411d3acb00000e83539c3/frameset.htm

2. Regarding the Function Module that you have asked for,

the function group SENT contains some function modules and utilities for the SAP Lock Concept. Of particular interest to us are the two FMs ENQUE_REPORT and ENQUEUE_REPORT. I have not researched thoroughly as to the functionalitites of these two FMs and I'm leaving that for you to pursue.

You might want to write a customized report using one (or both?) of these FMs and trigger a workflow / external email based on the tolerance levels of your choice.

Hope this information helps you solve the problem. Please do get back to me in case you have some other doubts regarding this.

Regards,

Anand Mandalika.

[Former Member · Accepted solution]

Hi Anand,

Thanks for your response. The link is very helpful. Do you happen to have a sample code to read the function module enqueueread.

Also, in SM12 when I click on Extras--> Statistics; nothing happens: SM12 Screen has following entries when I try to run Statistics :

Tablename <blank>

LockArgument<blank> Client 010

Username*

We are on 4.7.

Thanks

Message was edited by: Naved Rehman

Message was edited by: Naved Rehman

[Former Member · Accepted solution]

Hi,

Please tell me what is the name of the FM?

Thanks in Advance

Priya