Mention and explain the contention situations caused by locks?
Answer Posted / ereshwari
Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 connect?
Explain about dbrm.
What is access path in db2?
What is db2 catalog database?
What is database alias db2?
Mention the downsides of page level lock.
Name the lockable units in DB2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which isolation level provides maximum concurrency?
What is the difference between db2 and oracle?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to rename a table in DB2 ?
What is collection in db2 bind?
How to compare data between two tables in db2?
What is buffer pool in the db2 database?