This function returns information for latches which have been involved in extended latch waits. This information includes the member, latch name, number of extended waits, and time spent in extended waits.
None
The MON_GET_EXTENDED_LATCH_WAIT returns informations about which latches on a given member have been involved in extended latch waits, including how much time and how many times the particular latch has been involved in extended latch waits. This information will be collected as part of the base monitor metrics.
Column Name | Data Type | Description |
---|---|---|
MEMBER | SMALLINT | member- Database member |
LATCH_NAME | VARCHAR(256) | The name of the latch. This value corresponds to latch names that are reported in DB2® diagnostic files such as the db2diag log files or the stack files. |
TOTAL_EXTENDED_LATCH_WAITS | BIGINT | total_extended_latch_waits - Total extended latch waits |
TOTAL_EXTENDED_LATCH_WAIT_TIME | BIGINT | total_extended_latch_wait_time - Total extended latch wait time |