Failed SQL (%) - Database

Identifier:db2.db_pct_failed_sql_stmts

Database Object Monitored:Database

Category:SQL Statement Activity

Description:Percentage of SQL statements that failed during the interval

Equation:100 * DELTA(database.failed_sql_stmts) / DELTA(database.static_sql_stmts + database.dynamic_sql_stmts)

Usage Notes:The percentage of SQL statements that received a negative SQL code indicates a possible cause of poor performance. Failed SQL statements waste system resources.