Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14574 Views
- IBM, SUN, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nahid gorji
-Minimize the lock size as much as possible.
- Maximize the sharing of the resource by using CS or UR
Isolation levels when possible.
- Minimize the number of rows in one page for frequently
used tables if you want to avoid row locksize.
- use CURRENTDATA( NO) to avoid acuiring locks.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / durga prasad
Increasing or decreasing maxlocks or locklist should be
taken from a memory point of view .but the primary thing to
be done is to reduce the work load into subunits so that
lager resultset is not created and try to use cs isolation
level where ever possible because using rr or rs isolation
level is an invitation for deadlocks.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sheida bamdad
My name is Sheida Bamdad and would like to have Nahid
Gorji's contact information. Can yo help me with this
matter?
| Is This Answer Correct ? | 1 Yes | 3 No |
What is check constraint in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Update command
How to access db2 tables in mainframe?
What is EXPLAIN?
what is check point and restart Logic ? why do we go for that ??
what is a plan and how do you refer the plan in the program?
What is scrollable cursor in db2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is COPY PENDING status?
How to solve S0C7 abend with out using DISPlay in 10 mins?
can we update the table by using cursors can anyone post the query?
COBOL 
