DB2 Version 9.7 for Linux, UNIX, and Windows

int_commits - Internal commits monitor element

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

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) REQUEST METRICS BASE
Table 2. 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 3. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db -
Connection event_conn -
Statistics event_scstats (reported in the metrics document) REQUEST METRICS BASE
Statistics event_wlstats (reported in the metrics document) REQUEST METRICS BASE

Unit of work

Reported in the in the system_metrics document.

REQUEST METRICS BASE

Statistics event_scmetrics* REQUEST METRICS BASE
Statistics event_wlmetrics* REQUEST METRICS BASE
* When returned as part of this logical data group, this element reflects the change in value of this metric since the last statistics collection or database activation, whichever was more recent.

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_sql_stmts
 + int_commits
 + rollback_sql_stmts
 + int_rollbacks
Note: The units of work calculated will only 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.