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 table function - Return a list of activities	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	Always collected

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	Always collected
Locking	lock_participant_activities	Always collected

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. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_ACTIVITY table function - Return a list of activities	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details	Always collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	Always collected

Table 4. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Activities	event_activity	Always collected
Application	stmt	Statement
DCS Statement	dcs_stmt	Statement

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 5. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities	Always collected
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 6. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	stmt	Statement
DCS Statement	dcs_stmt	Statement

Table 7. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	Always collected
Package cache	pkgcache	Always collected

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 8. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_ACTIVITY table function - Return a list of activities	Always collected
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
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	Always collected

Table 9. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	Always collected
Package cache	pkgcache	Always collected

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 10. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected

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

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 12. 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 13. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
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

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 15. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected

Table 16. 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 17. 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.

This element is an alias for the quiescer_application_handle monitor element.

Element identifier: quiescer_agent_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_auth_id to determine who is responsible for quiescing a table space.

quiescer_application_handle - Quiescer application handle monitor element

Application handle of the application that is holding a quiesce state.

This element is an alias for the quiescer_agent_id monitor element.

Table 19. Table function monitoring information
Table function	Monitor element collection level
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces	Always collected

Usage

Use this element with the quiescer_auth_id monitor element to determine what quiesced 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 20. Table function monitoring information
Table function	Monitor element collection level
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces	Always collected

Table 21. 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 22. Table function monitoring information
Table function	Monitor element collection level
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces	Always collected

Table 23. 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 24. 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 25. Table function monitoring information
Table function	Monitor element collection level
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces	Always collected

Table 26. 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.