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.

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.

Answer / akbar

Adding to the second part of Bala:
There may be involvement of multiple application in
deadlock situations and not just 2.

Answer / ekalavya

USE AS MANY COMMITS IN THE PROGRAM.

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.

What language is db2 written in?

0 Answers  

What is release/acquire in bind?

0 Answers  

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

how to fetch first 100 rows in db2

2 Answers   IBM,

how to resolve -811

2 Answers   IBM,

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

What is the difference between bind and rebind in db2?

0 Answers  

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

What is bind in db2?

0 Answers