Home > DeveloperSection > Interviews > What is lock escalation?

Posted on    March-28-2011 7:05 AM

 DB2 DB2 
Ratings:
 1 Answer(s)
  1161  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Points:690
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