DB2 Version 9.7 for Linux, UNIX, and Windows

int_deadlock_rollbacks - Internal Rollbacks Due To Deadlock monitor element

The total number of forced rollbacks initiated by the database manager due to a deadlock. A rollback is performed on the current unit of work in an application selected by the database manager to resolve the deadlock.

Element identifier: int_deadlock_rollbacks
Element type: counter

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic
Application	appl	Basic

For snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Connection	event_conn	-

Usage: This element shows the number of deadlocks that have been broken and can be used as an indicator of concurrency problems. It is important, since int_deadlock_rollbacks lower the throughput of the database.
This value is included in the value given by int_rollbacks.