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
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What are the benefits of using the db2 database?
What is db2 command?
Can we update view in db2?
What is the difference between bind and rebind in db2?
What parameters are used to control the free space in DB2?
Can we insert update delete in view?
Explain in detail about buffer manager and its functionalities?
Which command is used to remove all rows from a table?
What is drop table?
Mention data types used in db2 ?
What kind of database is db2?
Explain package in db2 and its advantages?
What is db2 bind?
Is db2 free?
