DB2 Version 9.7 for Linux, UNIX, and Windows

uid_sql_stmts - Update/Insert/Delete SQL Statements Executed monitor element

The number of SQL UPDATE, INSERT, and DELETE statements that were executed.

Table 1. 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 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-
Connection	event_conn	-

Usage

You can use this element to determine the level of database activity at the application or database level.

You can also use the following formula to determine the ratio of UPDATE, INSERT and DELETE statements to the total number of statements:

 
   uid_sql_stmts
 / (static_sql_stmts + dynamic_sql_stmts )

This information can be useful for analyzing application activity and throughput.