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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Explain about rct in db2?
Can we delete records from view?
What is a predicate?
What do you mean by NOT NULL? When will you use it?
What is the connection string to connect to the DB2 Database ?
How would the varchar column remarks defined?
How do I change the column size in db2?
What is db2 instance?
What is role in db2?
What is a LIKE table and how is it created?
What is isolation level?