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

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 ?

0 Answers   JPMorgan Chase,


What is host variable?

0 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What is a clustering index ?

3 Answers  


What is a thread?

3 Answers  






What is bind package and plan in db2?

0 Answers  


How would the varchar column remarks defined?

0 Answers  


I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,


What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  


What is a DB2 bind?

3 Answers  


What is cloudant database?

0 Answers  


Categories