Identifier:db2.db_avg_lock_wait_time
Database Object Monitored:Database
Category:Lock and Deadlock
Description:Average lock wait time for lock waits during the interval (seconds)
Equation:DELTA(database.lock_wait_time / 1000) / DELTA(database.lock_waits)
Usage Notes:At the database level, this is the average lock wait time for all lock waits experienced by all applications connected to this particular database in the past interval. Use this performance variable to identify if applications are spending excessive time waiting for a lock. This can point to a possible concurrency problem with the database. See the lock details screen.