Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14426 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
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 are the various isolation levels possible?
Give the name of some fields form sqlca.
What is collection in db2 bind?
What is schema in db2?
Define predicate?
What are bind parameters in db2?
List out the data types available.
What is host variable?
What do you mean by storage group (stogroup)?
What is reorg?
What kind of database is db2?
How do I delete a table in database?
What is db2 stogroup?
Are view updateable?
