DB2 Version 9.7 for Linux, UNIX, and Windows

hld_member - Database member for application holding lock

Database member where the lock is being held by the holding application.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_APPL_LOCKWAIT table function - get information about locks for which an application is waiting

Usage

If the lock is being held on a remote member, the value of hld_member is -2. To determine which member the lock is being held at, use the MON_GET_LOCKS table function and specify the lock_name as a search argument.