Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve deadlock issue
- 5 Answers
- 20318 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 is a result table?
What is EXPLAIN?
How can we retrieve the total number of records in RPG & CLLE?
What is cursor?
How do I copy a table in db2?
Define declaration generator (dclgen).
What is page size in db2?
On the create tablespace, what does the CLOSE parameter do?
Why cursor is used in db2?
How do you select a row using indexes in db2?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
Explain in detail about buffer manager and its functionalities?
COBOL 
