Snapshot Information Level Database Application |
API Structure(s) sqlm_dbase sqlm_appl |
Monitor Group Basic Basic |
Resettable |
Yes |
|
Event Information Level Connection |
API Structure(s) sqlm_conn_event |
|
API 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".
[ Top of Page | Table of Contents | Glossary | Index ]