The type of the histogram, in string format.
There are six histogram types.
- CoordActQueueTime
- A histogram of the time (in milliseconds) non-nested
activities spend queued (for example, in a threshold queue), measured
on the coordinator partition.
- CoordActExecTime
- A histogram of the time (in milliseconds)
non-nested activities spend executing at the coordinator partition.
Execution time does not include time spent initializing or queued.
For cursors, execution time includes only the time spent on open,
fetch and close requests. When an activity
is remapped between service subclasses, the execution time histogram
is updated only for the service subclass in which the activity completes
execution.
- CoordActLifetime
- A histogram of
the elapsed time (in milliseconds) from when a non-nested activity
is identified by the database manager until the activity completes
execution, as measured on the coordinator partition. When
you remap activities between service subclasses, the lifetime histogram
is updated only for the service subclass in which the activity completes
execution.
- CoordActInterArrivalTime
- A histogram of the time interval (in milliseconds)
between the arrival of non-nested coordinator activities. The
inter-arrival time mean is calculated for service subclasses through
which activities enter the system. When you remap activities between
service subclasses, the inter-arrival time histogram of the service
subclass you remap an activity to is unaffected.
- CoordActEstCost
- A histogram of the estimated cost (in timerons)
of non-nested DML activities. The estimated
cost of an activity is counted only towards the service subclass in
which the activity enters the system.
- ReqExecTime
- A histogram of request execution times (in milliseconds),
which includes requests on the coordinator partition, and any subrequests
on both coordinator and non-coordinator partitions (like RPC requests
or SMP subagent requests). Requests included may or may not be associated
with an activity: Both PREPARE and OPEN requests are included in this
histogram, for example, but while OPEN requests are always associated
with a cursor activity, PREPARE requests are not part of any activity.The
execution time histogram of a service subclass involved in remapping
counts the portion of the execution time spent by the partial request
in the service subclass.
Table 1. Event Monitoring Information| Event Type |
Logical Data Grouping |
Monitor Switch |
|---|
| Statistics |
event_histogrambin |
- |
Usage
Use this element to identify the type
of histogram. Several histograms can belong to the same statistics
record, but only one of each type.
DB2 Version 9.7 for Linux, UNIX, and Windows