How to resolve deadlock issue

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

Question Posted / guest

5 Answers
17921 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to resolve deadlock issue..

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

How to resolve deadlock issue..

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

How to resolve deadlock issue..

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

How to resolve deadlock issue..

Answer / ekalavya

USE AS MANY COMMITS IN THE PROGRAM.

Is This Answer Correct ?

0 Yes

2 No

How to resolve deadlock issue..

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

Post New Answer