What techniques will be used to avoid deadlock??
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
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How would the varchar column remarks defined?
What is iseries database?
What is a dbrm in db2?
Explain packages.
What is rct?
What are concurrency issues?
What action db2 takes when a program aborts in the middle of a transaction?
What is runstats and reorg in db2?
What is db2 look?
What is difference between isnull and coalesce?
List down the data types in the db2 database.
What is image copy in db2?
What are the contents of dclgen?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?