Lock Table Overflow

[former_member618864]

Hi,

We had an "Lock table overflow"  issue for 30mins in our production system.. Without performing any manual actions locks got cleared after 1hr.
Now, the requirement for us is to identify who has chewed up all the resources to cause lock table overflow.. is there any way, where i can able to find out which user/transaction/program has made to happen lock overflow.

I had gone through couple of Note, SAP Recomended to update enque/table_size to avoid this problem. But, without identifying reason we don't want to increase the parameter. As, well as i also checked in STAD. But, i unable to find the exact information. Thanks in Advance.

Regards,

Raj

[S_Sriram · Accepted solution]

Hi Raj

1.  Could you share your SAP version details?

2. It may be problem in kernel level

    Kindly refer the SAP Note 746138 - Analyzing lock table overflows

1565578 - Lock Table Overflow

BR

SS

[former_member618864 · Accepted solution]

Hello Sriram,

Thanks for reply. I have already gone through this notes. With the nelp of Note "1565578 - Lock Table Overflow" we able to confirm lock overflow issue found on our environment.. I need to identify which program/user, made system to run in to overflow issue. Can you help where i can find application level with help of Txn/program..

Regards,

Raj

[Reagan · Accepted solution]

The notes provided by Sriram (especially 746138 - Analyzing lock table overflows) are the ones you need to follow. The lock table overflow information is stored in the ENQHISOVR file at the OS level. You can also check this file to see who and what was executed. Check this wiki page to know more - Enqueue - Application Server Infrastructure - SCN Wiki

RB