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".