What is lock escalation?
Answers were Sorted based on User's Feedback
Answer / s
When the number of row, page locks held per tablespace
exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock
is escalated to a tablespace lock
Is This Answer Correct ? | 19 Yes | 3 No |
Answer / andank
The Answer # 1 is perfect. When Lock esculation happens,
DB2 issues a warning message, DSNI031I.
Please beaware Lock Escalation and Lock Promotion are two
different concepts.
Lock promotion is the action of exchanging one lock on a
resource for a more restrictive lock on the same resource,
held by the same application process.
Is This Answer Correct ? | 4 Yes | 4 No |
What is innodb buffer pool?
What are the levels of isolation available with DB2V4
Why do chiropractors use drop table?
What Utility is used to migrate DB2 from one release to the next?
Which components manage deadlocks in db2?
Normalization in DB2 – first normal form, second normal form
what is + sign and -ve sign for sql code ?
Why cursor is used in db2?
What is cobol db2?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What language is db2 written in?
how 2 resolve the -311 sqlcode