DB2 Version 9.7 for Linux, UNIX, and Windows

commit_sql_stmts - Commit Statements Attempted monitor element

The total number of SQL COMMIT statements that have been attempted.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic
Database	dbase_remote	Basic
Application	appl	Basic
Application	appl_remote	Basic
DCS Database	dcs_dbase	Basic
DCS Application	dcs_appl	Basic

For snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-
Connection	event_conn	-

Usage

A small rate of change in this counter during the monitor period may indicate that applications are not doing frequent commits, which may lead to problems with logging and data concurrency.

You can also 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 a database or application level.