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 is db2 optimizer?
What is ibm db2 database?
What is declare cursor?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a page in db2?
How to take backup of table in db2?
What is meant by explain?
Can we delete records from view?
How to check table size in db2 sap?
How can you do the explain of a dynamic sql statement?
How to view db2 table structure?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Describe major components of db2?
What is netezza database?
What is difference between alias and synonym in db2?