DB2 Version 9.7 for Linux, UNIX, and Windows

static_sql_stmts - Static SQL Statements Attempted monitor element

The number of static 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	-

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