Average Locks Held Per App - Database

Identifier:db2.db_locks_held_per_appl

Database Object Monitored:Database

Category:Lock and Deadlock

Description:Average number of locks held per application

Equation:database.locks_held / database.appls_cur_cons

Usage Notes:Use this performance variable to identify if applications are holding too many locks, thereby causing concurrency problems. You can also use this performance variable to tune locklist and maxlocks.