Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve deadlock issue
- 5 Answers
- 20144 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ashish
Deadlock issue you get when suppose same table is being used
by many applications. The first solution is you should wait
for a while til other users use it. or you can get the
utility thread kill by Database Administrators.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / akbar
Adding to the second part of Bala:
There may be involvement of multiple application in
deadlock situations and not just 2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / angoca
Try to change the isolation level. Also, always reserve the
resources in the same order:
For breakfast, first pick cereal and then milk. Do not do
the opposite (milk then cereal), and this will reduce the
deadlock occurencies. They will be block at the first ressource.
| Is This Answer Correct ? | 0 Yes | 2 No |
What will the DB2 optimizer do?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What is an alias and how does it differ from a synonym?
What are the various data types available in db2?
What is a clustering index?
What is tablespace?
what are the bind parameters?
What is meant by a unit of recovery?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is a SELECT statement?
What is check constraint in db2?
Why cursor is used in db2?
COBOL 
