Hi Guys,


I wonder if someone can explain me why even though I have a deadlock event monitor ON I'm getting heaps of "Internal rollbacks due to deadlock" but I can't see anything in the event monitor. Also I wonder why for instance the "Deadlocks detected" is always 0 and the "Internal rollbacks due to deadlock" is a high number so I would've thought that "Deadlocks detected" counter should include any type/kind of deadlock even the internal ones. Is this correct. Thanks.

harbry.

Where are you seeing this? Are you sure it is not a locktimeout? A deadlock and a locktimeout are not the same thing.

Both a locktimeout and deadlock will result in -911, but the locktimeout has reason code 68, and the deadlock has reason code 2.

After you issue the :
db2 get snapshot for all on p01webd1 | grep -i "rollbacks" | more

You'll get something like this:
Internal rollbacks = 424
Internal rollbacks due to deadlock = 2221

You may need to reset the snaphot monitors, or determine if the number grows while you have the event monitor running.

I just found that this is due to a bug and it'll be fixed with DB2 FP13.

FP13 and FP14 are already released.