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 if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

What is the physical storage length of date data type?

0 Answers  

What is a host variable?

3 Answers  

What do you mean by commit and rollback?

0 Answers  

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

what is sql abend code -801,-802?

2 Answers  

what is rebinding ?

1 Answers   IBM,