Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14333 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
What is the use of runstats in db2?
What is coalesce in db2?
How to connect to db2 database from windows command line?
What is release/acquire in bind?
What is a trigger in the db2 database?
What is explain in db2?
How to get the ddl of a table in db2?
On which levels locks can be applied?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Is ibm db2 free?
What are the contents of dclgen?
What is temporal table in db2?
What is precompiler in db2?
How would you find out the total number of rows in a db2 table?
Define data page.
