Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 2 Answers
- 14396 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 iseries database?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the self-referencing constraint?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What's The Error Code For Unique Index Voilation?
What DB2 Catalog column tell you when an index needs table reorganized ?
What are db2 tables?
What is the clustering index in the db2 database?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What does DSNDB07 database do?
what needs to be done if a table is in copy pending / check pending status?
COBOL 
