Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14571 Views
- IBM, SUN, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Mention some fields that are a part of sqlca.
Explain how can you do the explain of a dynamic sql statement?
How can you classify the locks in db2?
How can deadlocks be resolved?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the use of value function?
How to compare data between two tables in db2?
What is bind and rebind in db2?
Why do we need reorg in db2?
What is runstats db2?
What is db2 stogroup?
Explain in detail about buffer manager and its functionalities?
What is cursor with hold option in db2?
What is db2 plan table?
