Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14339 Views
- IBM, SUN, I also Faced
- E-Mail Answers
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 are the bind parameters ibm db2?
What are db2 tables?
How do I start db2 in windows?
How can the duplicate values be eliminated from db2 select?
What are union and union all?
Explain various types of locks in db2?
What is meant by explain?
What is dbrm? What it contains? When it will be created?
Why do chiropractors use drop table?
What action db2 takes when a program aborts in the middle of a transaction?
List some fields from sqlca?
What is buffer pool and list some of them?
How to view db2 table structure?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the two types of logging in the db2 database? Explain them.
