Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14158 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 |
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is the physical storage length of date data type?
What information can you find in SYSIBM.SYSLINKS table?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How to create backup table in db2?
What is a result table?
What is performance tuning db2?
what is difference between Plan and Package
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
How do I optimize a query in db2?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
How to check last update on table in db2?
COBOL 
