Lock Timeouts - Database

Identifier:db2.db_lock_timeouts

Database Object Monitored:Database

Category:Lock and Deadlock

Description:Lock timeouts during the interval

Equation:DELTA(database.lock_timeouts)

Usage Notes:When a unit of work exceeds the maximum allowable amount of time, a lock timeout occurs and the unit of work isn't granted the lock it has been waiting for. This may mean an application is holding locks longer than required, or it may require adjustment of the locktimeout configuration parameter. Commiting can also free locks.