DB2 Version 9.7 for Linux, UNIX, and Windows

qp_query_id - Query patroller query ID monitor element

The query ID assigned to this activity by Query Patroller if the activity is a query. A query ID of 0 indicates that Query Patroller did not assign a query ID to this activity.

Important: The qp_query_id monitor element is deprecated because it is associated with Query Patroller functionality. With the new workload management features introduced in DB2® Version 9.5, Query Patroller and its related components have been deprecated in Version 9.7 and might be removed in a future release.
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

Parent topic: Database system monitor elements