DB2 Version 9.7 for Linux, UNIX, and Windows

select_sql_stmts - Select SQL Statements Executed monitor element

The number of SQL SELECT statements that were executed.

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 SELECT statements to the total statements:

 
      select_sql_stmts
    / ( static_sql_stmts
      + dynamic_sql_stmts )

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