Answer Posted / 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 |
Post New Answer View All Answers
What is an instance in db2?
How to access db2 tables in mainframe?
What is reorg?
How to restart a DB2 program?
What is plan in cobol db2?
What is the purpose of using commit?
Which component is responsible for db2 startup and shutdown?
Can you use max on a char column?
What does db2 blu stand for?
How do I add a column to an existing table in db2?
What does db2 plan contain?
what is diffrence b/w file-aid tool and file-aid utility???
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Differentiate between cs and rr isolation levels? Where do you specify them?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference