Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 2 Answers
- 14392 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 |
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What does db2 mean?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What parameters are used to control the free space in DB2?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is deadlock in db2?
What is an access path?
What is coalesce in db2?
How to define the a field which accepts value till 99999.99 in db2
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is the maximum length of sqlca?
On which levels locks can be applied?
COBOL 
