Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14164 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 |
Are views updatable ?
When is the results table for the query in a DECLARE CURSOR statement created?
List down the data types in the db2 database.
What is a clustered index?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
Can a array declared with an index be displayed(readable format) in spool?
What is meant by union and union all?
When do you use the IMAGECOPY?
What is the syntax for creating a table in the db2 database?
COBOL 
