Answer Posted / angoca
Try to change the isolation level. Also, always reserve the
resources in the same order:
For breakfast, first pick cereal and then milk. Do not do
the opposite (milk then cereal), and this will reduce the
deadlock occurencies. They will be block at the first ressource.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the physical storage length of the data types date, time, and timestamp?
What is db2 optimizer?
What is the maximum size of a char data type in db2?
What is the role of data manager in the db2 database?
What are db2 objects?
How to run db2 command in windows?
What is reorg?
What is runstats and reorg in db2?
How many databases are there?
Which component is responsible for processing sql statements and selecting access paths?
Mention data types used in db2 ?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is role in db2?
How will you return the number of records in table?
What is a db2 schema?