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 SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  


What does the sqlcode of -818 pertain to?

3 Answers  


What is rct?

0 Answers  


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  






What is netezza database?

0 Answers  


What is bind plan?

0 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,


What is database alias db2?

0 Answers  


what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,


Categories