The metrics in this category provide information about database locks.
Default Collection Interval - Every 30 minutes
Table 2-43 Lock Waits Metrics
| Metric | Description |
|---|---|
|
Lock Request Agent ID |
The ID of the agent waiting on a lock. |
|
Lock Name |
The name of the lock being waited on. |
|
Lock Object Type |
The object type of the lock being waited on. |
|
Locked Schema |
The schema containing the locked table. No value if the lock does not reference a table. |
|
Locked Table |
The locked table being waited on. No value if the lock does not reference a table. |
|
Lock Wait Duration (s) |
The time, in seconds, this agent has been waiting for access. |
|
Application Requesting Lock |
The name of the application wanting to acquire the lock. |
|
User Requesting Lock |
The authorization ID of the session that wants to acquire the lock. |
|
Application Holding Lock |
The application holding the lock blocking access. |
|
User Holding Lock |
The authorization ID of the session holding the lock blocking access |
|
SQL Statement Requesting Lock |
The SQL statement text being executed by the application requesting the lock. Only available on on versions of DB2 9.7 and later. |
|
SQL Statement Holding Lock |
The SQL statement text associated with the application holding the lock. This is not necessarily the statement responsible for the lock. Only available on versions of DB2 9.7 and later. |