IBM Books

Static SQL 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

static_sql_stmts
counter

 

Description:  The number of static SQL statements that were attempted.

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

      Dynamic SQL Statements Attempted
    + Static SQL Statements Attempted
    - Failed Statement Operations
    = throughput during monitoring period

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

[ DB2 List of Books | Search the DB2 Books ]