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

vectored_ios - Number of vectored I/O requests monitor element

The number of vectored I/O requests. More specifically, the number of times the database prefetches pages into the page area of the buffer pool.

Table 2. 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_DATABASE table function - Get database level information DATA OBJECT METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics DATA OBJECT METRICS BASE
MON_GET_TABLESPACE table function - Get table space metrics DATA OBJECT METRICS BASE
Table 3. 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 4. 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.

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 5. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 6. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected

Usage

This metric reports point in time information at statistics event monitor record generation.

virtual_mem_reserved - Reserved virtual memory monitor element

The amount of virtual memory reserved by running processes, in MB.

Table 7. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 8. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected

Usage

This metric reports point in time information at statistics event monitor record generation.

virtual_mem_total - Total virtual memory monitor element

The total amount of virtual memory available on this host, in MB.

Table 9. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 10. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected

Usage

This metric reports point in time information at statistics event monitor record generation.