DB2 Version 9.7 for Linux, UNIX, and Windows

data_partition_id - Data partition identifier monitor element

The identifier of the data partition for which information is returned.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_TABLE table function - Get table metrics Always collected
MON_GET_INDEX table function - Get index metrics Always collected
Table 2. Snapshot monitoring information
Snapshot level Logical data grouping Monitor switch
Table table Basic
Lock lock Lock
Lock lock_wait Lock
Table 3. Event monitoring information
Event type Logical data grouping Monitor switch
Table event_table -
Deadlocks event_dlconn -
Deadlocks with Details event_detailed_dlconn -
Deadlocks lock -

Usage

This element is only applicable to partitioned tables and partitioned indexes. Otherwise, the value of this monitor element is NULL.

When returning lock level information, a value of -1 represents a lock which controls access to the whole table.

Parent topic: Database system monitor elements