Commit Statements Attempted

Snapshot Information Level Database Application	API Structure(s) sqlm_dbase sqlm_appl	Monitor Group Basic Basic
Resettable	Yes
Event Information Level Database Connection	API Structure(s) sqlm_db_event sqlm_conn_event
API Element Name Element Type	commit_sql_stmts counter

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

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 statements attempted
 + internal commits
 + rollback statements attempted
 + internal 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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]