Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve deadlock issue
- 5 Answers
- 20099 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 10 Yes | 1 No |
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.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / akbar
Adding to the second part of Bala:
There may be involvement of multiple application in
deadlock situations and not just 2.
| Is This Answer Correct ? | 0 Yes | 0 No |
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 This Answer Correct ? | 0 Yes | 2 No |
what is the role of the cursor in db2?
Compare a subselect to a join?
What is check constraint. Explain with example.
List out the data types available.
Where would you find information about the type of database authority held by the user?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is plan in cobol db2?
What is a cursor and what is its function?
Explain what a plan is?
how we will do null data selection in cobol-db2 program
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is role in db2?
COBOL 
