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 |
failed_sql_stmts counter |
Description: The number of SQL statements that were attempted, but failed.
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
This count includes all SQL statements that received a negative SQLCODE.
This element may also help you in determining reasons for poor performance, since failed statements mean time wasted by the database manager and as a result, lower throughput for the database.
[ Top of Page | Table of Contents | Glossary | Index ]