DB2 Version 9.7 for Linux, UNIX, and Windows

effective_lock_timeout - Effective lock timeout monitor element

The effective lock timeout value for this activity. This value is reported in seconds.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Command and Level
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) Always collected

Usage