V
valid - Section validity indicator monitor element
Indicates whether the dynamic SQL statement section is valid. For static SQL statements, the value of this monitor element is always Y.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache | Always collected |
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries | Always collected |
Usage
Valid values for this monitor element are Y and N. An invalid section is implicitly prepared by the system when next used.
- SQL objects that the statement depends on directly or indirectly are altered or dropped
- Privileges that are required by the authorization ID used to prepare the statement are revoked
utility_type - Utility Type monitor element
The class of utility.
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Database Manager | utility_info | Basic |
Event Type | Logical Data Grouping | Monitor element collection level |
---|---|---|
Change history | changesummary utillocation utilphase utilstart utilstop |
Always collected |
Usage
The values for this element can be any of the constants defined in sqlmon.h with names beginning "SQLM_UTILITY_".
- ASYNC_INDEX_CLEANUP
- ASYNC_PART_DETACH
- BACKUP
- CRASH_RECOVERY
- GROUP_CRASH_RECOVERY
- LOAD
- MDC_ROLLOUT_CLEANUP
- MEMBER_CRASH_RECOVERY
- REBALANCE
- REDISTRIBUTE
- RESTART_RECREATE_INDEX
- RESTORE
- ROLLFORWARD_RECOVERY
- RUNSTATS
- BACKUP
- LOAD
- MOVETABLE
- REDISTRIBUTE
- REORG
- RESTORE
- ROLLFORWARD
- RUNSTATS
valid - Section validity indicator monitor element
Indicates whether the dynamic SQL statement section is valid. For static SQL statements, the value of this monitor element is always Y.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache | Always collected |
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries | Always collected |
Usage
Valid values for this monitor element are Y and N. An invalid section is implicitly prepared by the system when next used.
- SQL objects that the statement depends on directly or indirectly are altered or dropped
- Privileges that are required by the authorization ID used to prepare the statement are revoked
vectored_ios - Number of vectored I/O requests monitor element
The number of vectored I/O requests. More specifically, the number of times DB2® performs prefetching of pages into the page area of the buffer pool.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_BUFFERPOOL table function - Get buffer pool metrics | DATA OBJECT METRICS BASE |
MON_GET_CONTAINER table function - Get table space container metrics | DATA OBJECT METRICS BASE |
MON_GET_TABLESPACE table function - Get table space metrics | DATA OBJECT METRICS BASE |
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Buffer Pool | bufferpool | Buffer Pool |
Usage
Use this element to determine how often vectored I/O is being done. The number of vectored I/O requests is monitored only during prefetching.
version - Version of Monitor Data monitor element
The version of the database manager that produced the event monitor data stream.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Event Log Header | event_log_header | - |
Usage
The data structures used by the event monitor may change between releases of the database manager. As a result, your monitor applications should check the version of the data stream to determine if they can process the data they will be receiving.
For this release, this element is set to the API constant SQLM_DBMON_VERSION9_5.
virtual_mem_free - Free virtual memory monitor element
The amount of virtual memory available on this host that is not allocated to any process, in MB.
Table Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |
virtual_mem_reserved - Reserved virtual memory monitor element
The amount of virtual memory reserved by running processes, in MB.
Table Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |
virtual_mem_total - Total virtual memory monitor element
The total amount of virtual memory available on this host, in MB.
Table Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |