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.

How could one combine a set of incremental image copies into a single copy?

1 Answers  

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

What are the prerogatives?

0 Answers  

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

What is phantom read in db2?

0 Answers  

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

Discuss about db2 bind?

0 Answers  

wht are the restrictions for union ?

2 Answers   CTS,

Update command

1 Answers  

What is cursor in dbms?

0 Answers