Skip to Content
author's profile photo Former Member
Former Member

Lock Table Overflow

Hi Friends,

Today while monitoring the Quality system i came accross error logs related to lock table overflow.

1) I checked the paramter enque/table_size(currently maintained at 8 MB). the default value is 4 MB. on central instance.

2)check for ENQ, UPD,UP2 wp(there are all available)

3) check sm12(lock entries), sm13(for cancelled updates).

There are around 31 lock entries as of now. and no cancelled updates.

I have always seen locks in more number while monitoring but i never came accross this situation.

could you please tell me what else do we need to check.

Thanks,

Vijay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2008 at 10:14 AM

    Hi

    Please have a look at sap note [746138 - Analyzing lock table overflows|https://service.sap.com/sap/bc/bsp/spn/sapnotes/index2.htm?numm=746138]

    It describes a way to find out who caused the last overflow. You can then ask him/her what he was doing and then decide how to prevent future overflows.

    Best regards

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2008 at 10:00 AM

    while updating/deleting records from database may cause lock table overflow, check whether the locks was from only specific table?

    cheers,

    -Sunil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 07, 2008 at 12:51 PM

    increase value of enque/table_size in RZ10, restart system.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2008 at 01:34 AM

    What is ur operating system, if its unix try to look for nfile(Hp ux), lsof (list of open files)--> this is Generic Unix command to see the list of open files on all the unix systems.

    If the lsof returns with more than the value configured, then ur system will hung in its operations.

    If this is due to enque server check the sm13 if there are any update processing requests awaiting.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.