View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 06:56 PM
xixi
 
Posts: n/a
Default why lock escalation happened

hi, we are using db2 udb v8.1 on 64 bit windows, this message is in
the db2diag.log file

ADM5502W The escalation of "38200" locks on table "xxx.xxx" to lock
intent "X" was successful.


currently i have locklist = 1075, maxlock=60, so based on the formula

(((locks held * 36)/ (locklist *4096)) *100) , i have the answer is
31, compare with maxlock 60, i should still have space for locks to
grow, so why this point the escalation happened?
Reply With Quote