Identifier:db2.db_pct_dlck_rollbacks
Database Object Monitored:Database
Category:Lock and Deadlock
Description:Percentage of rollbacks that are due to deadlock during the interval
Equation:100 * DELTA(database.int_deadlock_rollbacks) / DELTA(database.rollback_sql_stmts + database.int_rollbacks)
Usage Notes:This performance variable helps you determine if one of the causes of excessive rollbacks is deadlocks. If it is, applications need to be assessed for their efficiency.