WHAT IS LOCK ESCALATION?

Mahesh Rawat

Total Post:138

Points:690
Posted by  Mahesh Rawat
DB2 
DB2
 1358  View(s)
Ratings:
Rate this:
  1. Mahesh Rawat

    Post:138

    Points:690
    What is lock escalation?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!