Internal Commits

 
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_commits
counter

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

Usage:  An internal commit may occur during any of the following:

• A reorganization
• An import
• A bind or pre-compile
• An application ends without executing an explicit SQL COMMIT statement (on UNIX).

This value, which does not include explicit SQL COMMIT statements, represents the number of these internal commits 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.

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

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