Snapshot Level Database Application DCS Database DCS Application |
Logical Data Grouping dbase appl dcs_dbase dcs_appl |
Monitor Switch Basic Basic Basic Basic |
Resettable |
Yes |
|
Event Type Database Connection |
Logical Data Grouping db_event conn_event |
|
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.