DB2 Help

Snapshot Level Database Application	Logical Data Grouping dbase appl	Monitor Switch Basic Basic
Resettable	Yes
Event Type Database Connection	Logical Data Grouping db_event conn_event
Element Name Element Type	int_rollbacks counter

Description: The total number of rollbacks initiated internally by the database manager.

Usage: An internal rollback occurs when any of the following cannot complete successfully:

A reorganization
An import
A bind or pre-compile
An application ends as a result of a deadlock situation or lock timeout situation
An application ends without executing an explicit commit or rollback statement (on Windows).

This value represents the number of these internal rollbacks since the later of:

The connection to the database (for database-level information, this is the time of the first connection)
The last reset of the database monitor counters.

While this value does not include explicit SQL ROLLBACK statements, the count from "Internal Rollbacks Due To Deadlock" is included.

You can use this element to calculate the total number of units of work by calculating the sum of the following:

 
   commit statements attempted
 + internal commits
 + rollback statements attempted
 + internal rollbacks

Note:

The units of work calculated will include those since the later of:

The connection to the database (for database-level information, this is the time of the first connection)
The last reset of the database monitor counters.

This calculation can be done at the application or the database level.