Lock table on DB2

[Former Member]

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

[Former Member]

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

[Former Member]

Hi, Chirag

What happens if LockList & MaxLocks set to automatic?

Will it grow indefinitely?

Is there a way to disable or avoid frequent Lock Escalation?

[michael_ruth3]

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

[former_member182505]

Hi

Please check the below may help you,

746138

1479593

1314750

1502194

Thanks

Sadiq