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 |
How do you retrieve the data from a nullable column?
What is db2 purescale?
What is reorg in database?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is meant by the attachment facility?
pls tell me abt the normalization five types....
What is a SELECT statement?
What is a db2 table?
What is a bind card?