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 1. Table Function Monitoring Information
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.

A dynamic statement section can become invalid when:
  • 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.

Table 2. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager utility_info Basic
Table 3. Event Monitoring Information
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_".

For the snapshot monitor interface, the utility type is one of:
  • 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
For the change history event monitor, the utility type is one of:
  • 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 4. Table Function Monitoring Information
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.

A dynamic statement section can become invalid when:
  • 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 5. Table Function Monitoring Information
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
Table 6. Snapshot Monitoring Information
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.

Table 7. Event Monitoring Information
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.