Lock release flags.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Lock |
lock |
Basic |
| Lock |
lock_wait |
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.
Usage
The following are
possible release
flag settings. Each release flag is based upon a bit flag value defined
in
sqlmon.h.
| API Constant |
Description |
|---|
| SQLM_LOCKRELFLAGS_SQLCOMPILER |
Locks by SQL compiler. |
| SQLM_LOCKRELFLAGS_UNTRACKED |
Non-unique, untracked locks. |
Note: All non-assigned bits are used for application
cursors.
DB2 Version 9.7 for Linux, UNIX, and Windows