Internal Rollbacks Due To Deadlock



Snapshot Level
Database
Application


Logical Data Grouping
dbase
appl


Monitor Switch
Basic
Basic


Resettable


Yes


 


Event Type
Connection


Logical Data Grouping
conn_event


 


Element Name
Element Type



int_deadlock_rollbacks
counter

 

Description:  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.

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 internal rollbacks due to deadlocks lower the throughput of the database.

This value is included in the value given by "Internal Rollbacks".