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 date data type?
What is rct?
What is a collection in db2?
Discuss about db2 bind?
What is the information associated with sysibm.syslinks table?
Which are the db2 tools to protect integrity of the database?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain the benefits you can get from mainframe connect?
What is a bind in db2?
List out the buffer pools in db2
How does coalesce work?
How can you count the number of rows from a table tab?
What is sqlca’s maximum length?
How to create backup table in db2?
Explain the contention situations caused by locks?