| Computers Forum Index » Computer - Databases - IBM DB2 » Deadlock reporting in database snapshots... |
|
Page 1 of 1 |
|
| Author |
Message |
| jefftyzzer... |
 Posted: Thu Oct 22, 2009 9:28 pm |
|
|
|
Guest
|
Friends,
If the "Internal rollbacks due to deadlock" monitor element counts "[t]
he total number of forced rollbacks initiated by the database manager
due to a deadlock," how can I then have the following situation:
<snip>
Deadlocks detected = 0
<snip>
Internal rollbacks due to deadlock = 41
<snip>
In other words, a value of 0 for deadlocks detected but a non-zero
value for the number of rollbacks forced due to deadlocks.
Environment is DB2 9.5 FP4 and OS is AIX 5.3
--Jeff |
|
|
| Back to top |
|
|
|
|
