Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14431 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
How is deadlock resolved?
What is check constraint in db2?
Explain the benefits you can get from mainframe connect?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is reorg?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do I change the column size in db2?
What is the syntax for FETCH in DB2 ?
What is data manager?
Is db2 relational database?
What is runstats db2?
What is a collection in db2?
How to restart a DB2 program?
What does db2 stand for?
what is a corelated subquerry?
