Answer Posted / bala
Dead lock occurs when two jobs/transactions are waiting for the resources from each other and gets locked up.
Transaction A cannot proceed further until Transaction B is complete
similary Transaction B cannot proceed until Transaction A is complete.
To solve this issue, one of the transaction should be stopped for other transaction to proceed successfully.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the physical storage length of time data type?
What are db2 objects?
What is the role of schema in the db2 database?
What are the contents of a dclmgen?
How do I add a column in db2?
How does a cursor work?
What is netezza database?
What is the max length of sqlca?
What is load replace in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Define predicate?
What is the use of db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What does db2 mean?
What is sqlca?