DB2 Version 9.7 for Linux, UNIX, and Windows

lock_wait_time_top - Lock wait time top monitor element

The high watermark for lock wait times of any request in a workload. Units are milliseconds. The lock_wait_time_top high watermark is always collected for workloads. A request contributes towards this high watermark only when request metrics are enabled.

Table 1. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_wlstats -

Usage

Use this element to determine the highest lock wait time of any request on a partition for a workload during the time interval collected.