DB2 Version 9.7 for Linux, UNIX, and Windows

lock_attributes - Lock attributes monitor element

The lock attributes of the application that is currently holding the lock.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_LOCKS table function - list all locks in the currently connected database
MON_GET_APPL_LOCKWAIT table function - get information about locks for which an application is waiting

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Lock	lock	Basic
Lock	lock_wait	Basic

1: This option has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

The following are possible lock attribute settings. Each lock attribute setting is based upon a bit flag value defined in sqlmon.h.

Lock Attribute Value in Table Functions	API Constant	Description
0000000000000001	SQLM_LOCKATTR_WAIT_FOR_AVAIL	Wait for availability.
0000000000000002	SQLM_LOCKATTR_ESCALATED	Acquired by escalation.
0000000000000004	SQLM_LOCKATTR_RR_IN_BLOCK	RR lock in block.
0000000000000008	SQLM_LOCKATTR_INSERT	Insert lock.
0000000000000010	SQLM_LOCKATTR_RR	Lock by RR scan.
0000000000000020	SQLM_LOCKATTR_UPDATE_DELETE	Update/delete row lock.
0000000000000040	SQLM_LOCKATTR_ALLOW_NEW	Allow new lock requests.
0000000000000080	SQLM_LOCKATTR_NEW_REQUEST	A new lock requestor.
0000000000000200	SQLM_LOCKATTR_INDOUBT	Lock held by Indoubt Transaction.
0000000000000400	SQLM_LOCKATTR_LOW_PRIORITY	Lock held by low priority application.

Bits returned that are not listed in the table above are reserved for internal use.