Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14573 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 kind of database is db2?
Is db2 a mainframe?
What is the maximum number of columns in a db2 table?
What is a page in db2?
List down the types of triggers in the db2 database?
What is db2 and what is the use of db2 optimizer?
What is the maximum length of sqlca?
What is a db2 tablespace?
What do you mean by commit and rollback?
What is the difference between dbm cfg and db cfg file in db2 ?
What is difference between isnull and coalesce?
What are the 2 sqlcodes that are returned?
How do I add a column to an existing table in db2?
How to restart a DB2 program?
Give the name of some fields form sqlca.
