7/04/2016

Overview of LOCK ISSUES in DB2

In this post we are going to discuss about three main lock issues:

  •        > Lock Escalations
  •        > Lock Waits
  •        > DeadLocks

Lock Escalations:

How many of you know that locks will also use memory? Yes they uses a a certain amount of memory and CPU. Sometimes there may be many row level locks present on a single table. So it may lead to more usage of memory and CPU. This this kind of scenarios DB2 automatically acquire a table level lock by replacing all the row level locks to free up the lock memory. This is know as "Lock Escalation".

ads