DB2 Version 10.1 for Linux, UNIX, and Windows

mon_lw_thresh - Monitoring lock wait threshold configuration parameter

This parameter controls the amount of time spent in lock wait before an event for mon_lockwait is generated.

Configuration type

Database

Parameter type

Configurable online

Default [range]

5000000 [1000 ... MAX_INT]

Upgrade Note

On databases created before V9.7 and then upgraded to V9.7 or higher, the mon_lw_thresh parameter is set to 4294967295 by default.

Unit of measure

Microseconds

When this parameter is set both at the database level and at the workload level, the shorter of the two configured times is considered for the given workload.