Mention and explain the contention situations caused by locks?



Mention and explain the contention situations caused by locks?..

Answer / ereshwari

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is db2? Explain.

0 Answers  


What is bind and rebind in db2?

0 Answers  


What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,


What is DCLGEN ?

3 Answers  


What is the physical storage length of time data type?

0 Answers  






How can you split a table in to exactly half?

7 Answers   HSBC,


what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,


What is reorg and runstats in db2?

0 Answers  


What is Reorg Recovery? when will you run it?

2 Answers  


Is db2 a programming language?

0 Answers  


What is dbrm? What it contains?

0 Answers  


Which isolation level provides highest data integrity?

0 Answers  


Categories