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 a bind in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Explain about cursor stability?
How does coalesce work?
What is dbrm library?
What is the difference between bind and rebind in db2?
What is the role of union all and union
What is the syntax for FETCH in DB2 ?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How would you find out the total number of rows in a db2 table?
Can we insert update delete in view?
What is the difference between nvl and coalesce?
What is the physical storage length of the data types date, time, and timestamp?
How to find schema of a table in db2?
What is a db2 collection?
