Explain the contention situations caused by locks?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  


What are the different types of base tables?

0 Answers  


I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  


What does the sqlcode of -818 pertain to?

3 Answers  


What can the SET option of the Repair Utility accomplish?

1 Answers  






How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


What is catalog database in db2?

0 Answers  


query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


what is different three logs in DB2?

1 Answers   Syntel,


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


What is copy book?

1 Answers   Thomson Reuters,


Categories