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 are the contents of a dclmgen?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is db2 optimizer?
What is db2 look?
How do I delete a column in db2?
What is runstats and reorg in db2?
What is cursor with hold option in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is page size in db2?
Define sqlca.
Define db2.
Which is faster delete or truncate?
What is runstats db2?
Which are the db2 tools to protect integrity of the database?
What are host variables in db2?