dba-db2.com
ADM5500W DB2 is performing lock escalation

11 June,2013 by Jack Vamvas

ADM5500W  DB2 is performing lock escalation.  The total number of locks currently held is "817", and the target number of locks to hold is "408".    How can I resolve?

 

Check the current LOCKLIST level with :

  

db2 get db cfg for COMMDB | grep 'LOCKLIST'

Increase the database locklist size to 4096 pages. If the ADM5500W error message continues , double locklist i.e 8192

You can also adjust the locklist percentage used by one application with adjusting the MAXLOCKS

What happens if DB2 locklist is out of space for holding locks? Locks are escalated to table level

db2 connect to DB_NAME;
db2 update db cfg using locklist 4096;
--this is an optional , see notes earlier 

db2 update db cfg using maxlocks 60; 

 

Read More

OLTP performance checklist - DBA DB2

DB2 Tuning Toolkit – db2exfmt - DBA DB2

Author: Jack Vamvas(http://www.dba-db2.com)

Subscribe to DBA-DB2.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright