What techniques will be used to avoid deadlock??
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 |
How do you Load a table ?? and what is Load replace ?
When is the results table for the query in a DECLARE CURSOR statement created?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What are the isolation levels possible ?
What are the Isolation levels possible ?
how to resolve -805 . how to see dbrm and package not found
max number of columns in a db2 table?
What can the SET option of the Repair Utility accomplish?
What are the different types of base tables?
What is the cobol picture clause of the db2 data types date, time, timestamp?
how to resolve -805. give clear explination for that
Differentiate between cs and rr isolation levels? Where do you specify them?