How to resolve deadlock issue
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 if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
my project is insurance management system,how to explain my work environment in interview?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Suppose if I need to update a column, how you do that using cursor?
What is the physical storage length of date data type?
What is a host variable?
What do you mean by commit and rollback?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What keyword does an SQL SELECT statement use for a string search?
what is sql abend code -801,-802?
what is rebinding ?