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 the physical storage length of time data type?
How to select the duplicate rows from a table?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is difference between *omit and *nopass?
what is the use of commit ? and what is the syntax?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
How would the varchar column remarks defined?
Explain the EXPLAIN statement?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
how do you resolve -805?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?