Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 2 Answers
- 14346 Views
- I also Faced
- E-Mail Answers
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 |
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What are the different types of base tables?
Which component is responsible for processing sql statements and selecting access paths?
What are the three types of page locks that can be held?
What is difference between isnull and coalesce?
how to unload different table data into different gdg files/ vsam files.
how do we solve soc 7 and soc4 ?
What is a DB2 bind?
Can a Db2 table data be retrived through JCL?
What is cursor stability?
how can we find nth max salary from A table
What is coalesce in db2?
COBOL 
