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.

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

What are the various data types available in db2?

0 Answers  

What is db2 look?

0 Answers  

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

Which catalog tables contain authorization information?

1 Answers  

Is it possible using max on a char column?

0 Answers  

How to define the data items to receive the fetch items for the SQL?

2 Answers  

What is correlation names?

1 Answers  

What does DML stand for and what are some examples of it?

3 Answers   IBM,

what is the soft code for deadlock ?

2 Answers   Logica CMG,