W
wl_work_action_set_id - Workload work action set identifier monitor element
If this activity has been categorized into a work class of workload scope, this monitor element shows the ID of the work action set associated with the work class set to which the work class belongs. Otherwise, this monitor element shows the value of 0.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activities | event_activity | Always collected |
Usage
Use this monitor element, together with the wl_work_class_id monitor element, to uniquely identify the workload work class of the activity, if one exists.
wl_work_class_id - Workload work class identifier monitor element
If this activity has been categorized into a work class of workload scope, then this monitor element displays the identifier of the work class. Otherwise, this monitor element displays the value of 0.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activities | event_activity | Always collected |
Usage
Use this monitor element, together with the wl_work_action_set_id monitor element, to uniquely identify the workload work class of the activity, if one exists.
wlm_queue_assignments_total - Workload manager total queue assignments monitor element
The number of times that activities or connections have been queued by a WLM threshold.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
Activities | event_activitymetrics | ACTIVITY METRICS BASE |
Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Unit of work |
Reported in the system_metrics document. |
REQUEST METRICS BASE |
wlm_queue_time_total - Workload manager total queue time monitor element
The time spent waiting on a WLM queuing threshold. This value is given in milliseconds.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
Activities | event_activitymetrics | ACTIVITY METRICS BASE |
Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Unit of work |
Reported in the system_metrics document. |
REQUEST METRICS BASE |
wlo_completed_total - Workload occurrences completed total monitor element
The number of workload occurrences to complete since last reset.
Table Function | Monitor Element Collection Level |
---|---|
WLM_GET_WORKLOAD_STATS table function - Return workload statistics | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_wlstats | - |
Usage
Use this element to determine how many occurrences of a given workload are driving work into the system.
work_action_set_id - Work action set ID monitor element
The ID of the work action set to which this statistics record applies.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_histogrambin | Always collected |
Statistics | event_wcstats | Always collected |
Usage
Use this element in conjunction with other activity history elements for analysis of the behavior of an activity or with other statistics elements for analysis of a work class.
- The element is reported in an event_histogrambin logical data group.
- The histogram data is collected for an object that is not a work class.
work_action_set_name - Work action set name monitor element
The name of the work action set to which the statistics shown as part of this event are associated.
Table Function | Monitor Element Collection Level |
---|---|
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics | Always collected |
WLM_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_qstats | - |
Statistics | event_wcstats | - |
Usage
Use this element along with the work_class_name element to uniquely identify the work class whose statistics are being shown in this record or to uniquely identify the work class which is the domain of the threshold queue whose statistics are shown in this record.
work_class_id - Work class ID monitor element
The identifier of the work class to which this statistics record applies.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_wcstats | Always collected |
Statistics | event_histogrambin | Always collected |
Usage
Use this element in conjunction with other statistics elements for analysis of a work class.
- The element is reported in an event_histogrambin logical data group.
- The histogram data is collected for an object that is not a work class.
work_class_name - Work class name monitor element
The name of the work class to which the statistics shown as part of this event are associated.
Table Function | Monitor Element Collection Level |
---|---|
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics | Always collected |
WLM_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_qstats | - |
Statistics | event_wcstats | - |
Usage
Use this element along with the work_action_set_name element to uniquely identify the work class whose statistics are being shown in this record or to uniquely identify the work class which is the domain of the threshold queue whose statistics are shown in this record.
workload_id - Workload ID monitor element
An integer that uniquely identifies a workload.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_WORKLOAD table function - Get workload metrics | Always collected |
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics | Always collected |
MON_SAMPLE_WORKLOAD_METRICS - Get sample | Always collected |
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Application | appl_info | Basic |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Locking | - | Always collected |
Unit of work | - | Always collected |
Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
Unit of work | Reported in the system_metrics document. | Always collected |
Statistics | event_wlstats | Always collected |
Statistics | event_histogrambin | Always collected |
Activities | event_activity | Always collected |
Threshold violations | event_thresholdviolations | Always collected |
Usage
Use this ID to uniquely identify the workload to which this activity, application, histogram bin, or workload statistics record belongs.
- The element is reported in an event_histogrambin logical data group.
- The histogram data is collected for an object that is not a workload.
workload_name - Workload name monitor element
Name of the workload.
Table Function | Monitor Element Collection Level |
---|---|
MON_FORMAT_LOCK_NAME table function - Format the internal lock name and return details | Always collected |
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics | Always collected |
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics | Always collected |
MON_GET_WORKLOAD table function - Get workload metrics | Always collected |
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics | Always collected |
MON_SAMPLE_WORKLOAD_METRICS - Get sample | Always collected |
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics | Always collected |
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class | Always collected |
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences | Always collected |
WLM_GET_WORKLOAD_STATS table function - Return workload statistics | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Locking | - | Always collected |
Unit of work | - | Always collected |
Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
Unit of work | Reported in the system_metrics document. | Always collected |
Statistics | event_wlstats | Always collected |
Usage
In the statistics event monitor and workload table functions, the workload name identifies the workload for which statistics or metrics are being collected and reported. In the unit of work event monitor and unit of work table functions, the workload name identifies the workload that the unit of work was associated with.
Use the workload name to identify units of work or sets of information that apply to a particular workload of interest.
workload_occurrence_id - Workload occurrence identifier monitor element
The ID of the workload occurrence to which this activity belongs.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics | Always collected |
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics | Always collected |
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class | Always collected |
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Unit of work | - | Always collected |
Activities | event_activity | Always collected |
Usage
Use this to identify the workload occurrence that submitted the activity.
workload_occurrence_state - Workload occurrence state monitor element
The state of the workload occurrence.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics | Always collected |
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) | Always collected |
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences | Always collected |
Usage
- DECOUPLED
- Workload occurrence does not have a coordinator agent assigned (concentrator case).
- DISCONNECTPEND
- Workload occurrence is disconnecting from the database.
- FORCED
- Workload occurrence has been forced.
- INTERRUPTED
- Workload occurrence has been interrupted.
- QUEUED
- Workload occurrence coordinator agent is queued by a workload management queuing threshold. In a partitioned database environment, this state may indicate that the coordinator agent has made an RPC another member to obtain threshold tickets and has not yet received a response.
- TRANSIENT
- Workload occurrence has not yet been mapped to a service superclass.
- UOWEXEC
- Workload occurrence is processing a request.
- UOWWAIT
- Workload occurrence is waiting for a request from the client.