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 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 |
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 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 |
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.
- INSERT, UPDATE, and DELETE
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 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 |
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Application | stmt | Statement |
DCS Statement | dcs_stmt | Statement |
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.
query_data_tag_list - Estimated query data tag list monitor element
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 |
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 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 |
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.
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 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 |
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 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 |
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.
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
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 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 function | Monitor element collection level |
---|---|
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces | Always collected |
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 function | Monitor element collection level |
---|---|
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces | Always collected |
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
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 function | Monitor element collection level |
---|---|
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces | Always collected |
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.