DB2 Version 9.7 for Linux, UNIX, and Windows

section_type - Section type indicator monitor element

Indicates whether the SQL statement section is dynamic or static.

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
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache - COLLECT BASE DATA

Usage

The possible values for this monitor element are the following:
  • D: dynamic
  • S: static
Parent topic: Database system monitor elements