DB2 Version 9.7 for Linux, UNIX, and Windows

effective_query_degree - Effective query degree monitor element

The effective query degree of parallelism for this activity.

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
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - -
Parent topic: Database system monitor elements