DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
The number of locks currently held.
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_CONNECTION table function - Get connection metrics | Always collected |
| MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) | Always collected |
| MON_GET_UNIT_OF_WORK table function - Get unit of work metrics | Always collected |
| MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) | Always collected |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | dbase | Basic |
| Application | appl | Basic |
| Lock | db_lock_list | Basic |
| Lock | appl_lock_list | Basic |
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Deadlocks with Details | event_detailed_dlconn | - |
If the monitor information is at the database level, this is the total number of locks currently held by all applications in the database.
If the monitor information is at the application level, this is the total number of locks currently held by all agents for the application.