Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14231 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 does reorg do in db2?
What are the three DB2 date and time data types and their associated functions?
What is the use of predicate?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What are concurrency issues?
What is buffrpool? Where we use it ?
What is the information associated with sysibm.syslinks table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
what's the best lock size that you could use when you create a tablespace?
Explain an outer join?
The only place of VSAM KSDS in DB2 is?
COBOL 
