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 plan in cobol db2?
What is nvl in db2?
Explain the contention situations caused by locks?
What is runstats utility in db2?
What is the syntax for FETCH in DB2 ?
What is cursor with hold option in db2?
What is dbrm? What it contains? When it will be created?
What is explain plan in db2?
How to find schema of a table in db2?
Is db2 a mainframe?
How do I add a column to a table in db2?
How is deadlock resolved?
List down the data types in the db2 database.
What is the syntax for creating a table in the db2 database?
When the like statement is used?