DB2 Version 9.7 for Linux, UNIX, and Windows

dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element

The number of dynamic SQL statements that were attempted.

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	-

An occurrence of each of the following operations increments the value of the dynamic_sql_stmts monitor element by one.

Usage

You can use this element to calculate the total number of successful SQL statements at the database or application level:

 
      dynamic_sql_stmts
    + static_sql_stmts
    - failed_sql_stmts
    = throughput during monitoring period