DB2 Version 9.7 for Linux, UNIX, and Windows

estimatedsqlcost_threshold_violated - Estimated SQL cost threshold violated monitor element

This monitor element returns 'Yes' to indicate that the activity violated the ESTIMATEDSQLCOST threshold. 'No' indicates that the activity has not yet violated the threshold.

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

Usage

Use this element to determine if the activity violated the ESTIMATEDSQLCOST threshold that was applied to the activity.