Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 2 Answers
- 14376 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 is the cobol picture clause of the db2 data types date, time, timestamp?
What is index cardinality?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the meaning concurrency in the db2 database?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What information is contained in a SYSCOPY entry?
max number of columns in a db2 table?
define clustering index.
what are bind concepts in db2 cobol?
Define db2.
How can you get the number of rows impacted by the last executed query?
COBOL 
