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.

Is db2 free?

0 Answers  

What is image copy?

1 Answers   Virtusa,

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

How does db2 sample database connect?

0 Answers  

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

What is a LIKE table and how is it created?

2 Answers  

Are views updateable?

0 Answers  

What is view db2?

0 Answers  

What is a root page?

1 Answers  

What does reorg do in db2?

0 Answers  

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

What is dbrm in db2 database?

0 Answers