The type of object against which the application holds
a lock (for object-lock-level information), or the type of object
for which the application is waiting to obtain a lock (for application-level
and deadlock-level information).
Table 2. Snapshot Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor Switch |
|---|
| Application |
appl |
Lock |
| Lock |
appl_lock_list |
Lock |
| Lock |
lock |
Basic |
| Lock |
lock_wait |
Lock |
Table 3. Event Monitoring Information| Event Type |
Logical Data Grouping |
Monitor Switch |
|---|
| Locking |
- |
- |
| Deadlocks1 |
lock |
- |
| Deadlocks1 |
event_dlconn |
- |
| Deadlocks with Details1 |
event_detailed_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
This element can help you determine
the source of contention for resources.
For
snapshot monitoring and the deadlock
1 event monitor, the
object type identifiers are defined in
sqlmon.h.
The objects may be one of the following types:
- Table space (SQLM_TABLESPACE_LOCK in sqlmon.h)
- Table
- Buffer pool
- Block
- Record (or row)
- Data partition (SQLM_TABLE_PART_LOCK in sqlmon.h)
- Internal (another type of lock held internally by the database
manager)
- Automatic resize
- Automatic storage.
For the locking event monitor and the monitoring
table functions in Table 1, the possible values for the lock_object_type monitor
element are defined in Table 4.
Table 4. Possible values for lock_object_type
monitor element| Possible values |
Description |
|---|
| TABLE |
Table lock |
| ROW |
Row lock |
| TABLESPACE |
Table space lock |
| EOT |
End of table lock |
| KEYVALUE |
Key value lock |
| SYSBOOT |
Sysboot lock |
| PLAN |
Plan lock |
| VARIATION |
Variation lock |
| SEQUENCE |
Sequence lock |
| BUFFERPOOL |
Buffer pool lock |
| LOB |
LOB/Long region lock |
| CATALOG |
Catalog cache lock |
| ONLINE_BACKUP |
Online backup lock |
| OBJECT_TABLE |
Object table lock |
| ALTER_TABLE |
Table alter lock |
| DMS_SEQUENCE |
DMS sequence lock |
| REORG |
Inplace reorganization lock |
| MDC_BLOCK |
MDC block lock |
| TABLE_PARTITION |
Table partition lock |
| AUTORESIZE |
Autoresize lock |
| AUTOSTORAGE |
Autostorage lock |
| XMLPATH |
XML path lock |
| EXTENT_MOVEMENT |
Extent movement lock |
| WORKLOAD |
Workload authorization lock |
| FED_SERVER |
Federation server lock |
| FED_USER |
Federation user mapping lock |
| CHUNK |
Chunk lock |
| LOAD_PRE_PART |
Load table pre-partitioning lock |
| LOAD_PART |
Load table partitioning lock |
| LOAD_TS |
Loading table space lock |
| LONG_FIELD_ESC |
Long field escalation lock |
| LONG_FIELD_SPACE |
Long field buddy space lock |
DB2 Version 9.7 for Linux, UNIX, and Windows