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
Discuss about db2 bind?
What do you mean by storage group (stogroup)?
What is concurrency?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain the benefits you can get from mainframe connect?
Define check constraint.
What is reorg?
What r the comman abends in db2, jcl and cobol???????
Can you use max on a char column?
What is a storage group (stogroup)?
What is ibm db2 connect?
What is load replace in db2?
Name the various locking levels available?
Define declaration generator (dclgen).
What is the syntax for seeing the columns and data types of a table in the db2 database?