Q

query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element

The actual runtime degree of intrapartition parallelism reported at the statement, activity, transaction, or workload level.

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
Activities	-	Always collected
Locking

query_card_estimate - Query Number of Rows Estimate monitor element

An estimate of the number of rows that will be returned by a query.

Table 3. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	stmt	Statement
DCS Statement	dcs_stmt	Statement
Activities	event_activity	-

Usage

This estimate by the SQL compiler can be compared with the run time actuals.

This element also returns information for the following SQL statements when you are monitoring DB2 Connect.

INSERT, UPDATE, and DELETE
Indicates the number of rows affected.
PREPARE
Estimate of the number of rows that will be returned. Only collected if the DRDA server is DB2® for Linux®, UNIX, and Windows, DB2 for VM and VSE, or DB2 for OS/400®.
FETCH
Set to the number of rows fetched. Only collected if the DRDA server is DB2 for OS/400.

If information is not collected for a DRDA server, then the element is set to zero.

query_cost_estimate - Query cost estimate monitor element

Estimated cost for a query, as determined by the SQL compiler. This value is reported in timerons.

Table 4. 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
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected
WLM_GET_WORKLOAD_OCCURRENCE _ACTIVITIES table function - Return a list of activities	Always collected

Table 5. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	stmt	Statement
DCS Statement	dcs_stmt	Statement
Activities	event_activity	-
Package cache	-	COLLECT BASE DATA

Usage

This monitor element allows correlation of actual run time with the compile-time estimates.

This element also returns information for the following SQL statements when you are monitoring DB2 Connect.

PREPARE
Represents the relative cost of the prepared SQL statement.
FETCH
Contains the length of the row retrieved. Only collected if the DRDA server is DB2 for OS/400.

If information is not collected for a DRDA server, then the element is set to zero.

Note: If the DRDA server is DB2 for OS/390® and z/OS®, this estimate could be higher than 2**32 - 1 (the maximum integer number that can be expressed through an unsigned long variable). In that case, the value returned by the monitor for this element will be 2**32 - 1.

query_data_tag_list - Estimated query data tag list monitor element

The query_data_tag_list monitor element is a comma separated list of data tag values that the compiler estimates will be referenced in a statement. A data tag value is in the list if the compiler predicts the statement will access a table whose data table space has a non-zero data tag attribute defined. The list does not contain duplicate values.

Table 6. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details	Always collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected

Table 7. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	ACTIVITY METRICS BASE
Package cache	-	COLLECT BASE DATA

Usage note

If none of the data table spaces accessed by the query have a data tag defined, the list is empty.

queue_assignments_total - Queue assignments total monitor element

The number of times any connection or activity was assigned to this threshold queue since the last reset.

Table 8. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected

Table 9. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_qstats	-

Usage

This element can be used to determine the number of times any connection or activity was queued in this particular queue in a given period of time determined by the statistics collection interval. This can help to determine the effectiveness of queuing thresholds.

queue_start_time - Queue start timestamp monitor element

The date and time the application started waiting in the queue to to obtain a threshold ticket.

Table 10. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	lock_participants

queue_size_top - Queue size top monitor element

Highest queue size that has been reached since the last reset.

Table 11. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected

Table 12. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_qstats	-

Usage

Use this element to gauge the effectiveness of queuing thresholds and to detect when queuing is excessive.

queue_time_total - Queue time total monitor element

Sum of the times spent in the queue for all connections or activities placed in this queue since the last reset. Units are milliseconds.

Table 13. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected

Table 14. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_qstats	Always collected

This element is used to gauge the effectiveness of queuing thresholds and to detect when queuing is excessive.

Usage notes

queue_time_total is not reset at the end of a statistic collection interval. If queue_time_total is used over multiple intervals, it can be greater than the product of wlm_collect_int and queue_size_top.

queued_agents - Queued threshold agents monitor element

The total number of agents currently queued in the threshold.

Table 15. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	lock_participants

quiescer_agent_id - Quiescer Agent Identification monitor element

Agent ID of the agent holding a quiesce state.

Element identifier: quiescer_agent_id
Element type: information

Table 16. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace_quiescer	Basic

Usage: Use this element in conjunction with quiescer_auth_id to determine who is responsible for quiescing a table space.

quiescer_auth_id - Quiescer User Authorization Identification monitor element

Authorization ID of the user holding a quiesce state.

Element identifier: quiescer_auth_id
Element type: information

Table 17. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace_quiescer	Basic

Usage: Use this element to determine who is responsible for quiescing a table space.

quiescer_obj_id - Quiescer Object Identification monitor element

The object ID of the object that causes a table space to be quiesced.

Element identifier: quiescer_obj_id
Element type: information

Table 18. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace_quiescer	Basic

Usage: Use this element in conjunction with quiescer_ts_id and quiescer_auth_id to determine who is responsible for quiescing a table space. The value of this element matches a value from column TABLEID of view SYSCAT.TABLES.

quiescer_state - Quiescer State monitor element

The type of quiesce being done (for example, "SHARE", "INTENT TO UPDATE", or "EXCLUSIVE").

Element identifier: quiescer_state
Element type: information

Table 19. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace_quiescer	Basic

Usage: The value of this element matches the value of constants SQLB_QUIESCED_SHARE, SQLB_QUIESCED_UPDATE, or SQLB_QUIESCED_EXCLUSIVE from sqlutil.h.

quiescer_ts_id - Quiescer Table Space Identification monitor element

The table space ID of the object that causes a table space to be quiesced.

Element identifier: quiescer_ts_id
Element type: information

Table 20. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace_quiescer	Basic

Usage: Use this element in conjunction with quiescer_obj_id and quiescer_auth_id to determine who is responsible for quiescing a table space. The value of this element matches a value from column TBSPACEID of view SYSCAT.TABLES.