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

Lock table on DB2

Hi,

In the following SNOTE: 1172292 they are mentioning about the lock control table on DB2,

Symptom

On the 1st day of week FRP updates the stock data and deletes stock data from stock buffer table. This is causing
continuous overflow of the lock control table within DB2 database.

Can anybody please tell us what is this lock control table on DB2 ? how to see whether the lock control table is overflown ?

Are they talking about lock waits ? Kindly post your suggestions and comments.

Thanks & Regards,

DVRK

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 10, 2012 at 01:37 PM

    Lock tables were lock escalations, converted to a lock table, to free up space in the lock list. All associated with lock waits. DBA cockpit will show all of your locks.

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2012 at 07:21 AM

    Hi Rama,

    You can do couple of things here ...

    1) Check SM21 the culprit user and the tcode he/she using here which is causing lock escalation. If you do not get this handy you get the info from OS level(filename: ENQHISOVR ) under work directory.

    2) Check the DB parameter LOCKLIST and MAXLOCKS and see to it that they are set to AUTOMATIC.

    3) Also please see if any long running transaction is holding up and creating lock waiting/deadlock scenario.

    Hope this may help you along with above information.

    Thanks & Regards

    Chirag

    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.