Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is db2 optimizer?

1178


What is ibm db2 database?

951


What is declare cursor?

1043


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?

8994


What is a page in db2?

980


How to take backup of table in db2?

1021


What is meant by explain?

1062


Can we delete records from view?

915


How to check table size in db2 sap?

975


How can you do the explain of a dynamic sql statement?

1013


How to view db2 table structure?

960


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?

2338


Describe major components of db2?

1040


What is netezza database?

959


What is difference between alias and synonym in db2?

1067