Home > DeveloperSection > Interviews > What is lock escalation?

Posted on    March-28-2011 7:05 AM

 DB2 DB2 
 1 Answer(s)
  1147  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Posted on    March-28-2011 12:00 AM

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.

Don't want to miss updates? Please click the below button!

Follow MindStick