DB2 Version 9.7 for Linux, UNIX, and Windows

sqltempspace_threshold_id - SQL temporary space threshold ID monitor element

The ID of the SQLTEMPSPACE threshold that was applied to the activity.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Command and Level
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) Always collected

Usage

Use this element to understand which SQLTEMPSPACE threshold, if any, was applied to the activity.