Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 2 Answers
- 14508 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 should be specified along with a cursor in order to continue updating process after commit?
What action db2 takes when a program aborts in the middle of a transaction?
Q4. How will you get the count of record without using COUNT verb in query?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is access path in db2?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is package in db2 mainframe?
Is there any advantage to denormalizing DB2 tables?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Why cursor is used in db2?
What's The Percentage Free Space ?
COBOL 
