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