What techniques will be used to avoid deadlock??
Answer Posted / 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 |
Post New Answer View All Answers
What db2 400?
What is the maximum size of a char data type in db2?
What is innodb buffer pool?
What is db2 optimizer?
How to connect to db2 database from windows command line?
How is deadlock resolved?
How to test SQL -911 error while developing COB-DB2 program
What do you mean by cursor?
What is dbrm? What it contains?
How do I delete a column in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is host variable?
Explain the function done by data manager?
What does db2 plan contain?
Define buffer pool.