DB2 Version 9.7 for Linux, UNIX, and Windows

section_env - Section environment monitor element

A blob that contains the section for an SQL statement. It is the actual section contents, that is the executable form of the query plan.

Table 1. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activitystmt -
Package cache - COLLECT DETAILED DATA

Usage

Use this element with the section explain procedures to explain the statement and view the access plan for the statement.

Parent topic: Database system monitor elements
Related concepts:
Differences between section explain and EXPLAIN statement output
Guidelines for capturing section explain information