The number of holds placed on the lock. Holds
are placed
on locks by cursors registered with the WITH HOLD clause and some DB2® utilities. Locks with holds
are not released when transactions are committed.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Lock |
lock |
Basic |
Table 2. Event Monitoring Information| Event Type |
Logical
Data Grouping |
Monitor Switch |
|---|
| Locking |
- |
- |
| Deadlocks1 |
lock |
- |
| Deadlocks1 |
event_dlconn |
- |
- 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.
DB2 Version 9.7 for Linux, UNIX, and Windows