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 is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

What is index cardinality?

3 Answers  

What is meant by AUTO COMMIT?

3 Answers  

What is subquery ?

6 Answers  

What happens in bind step in a db2 program?

0 Answers  

What is explain plan in db2?

0 Answers  

Which is faster delete or truncate?

0 Answers  

How to restart a DB2 program?

0 Answers   Cognizant,

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers