Measure Reference Manual

In G-series and earlier RVUs, this is a 32-bit counter. In H-series and J-series RVUs, it is a 64-bit
counter.
In G-series RVUs, the DISC-READS-F field is a 64-bit version of DISC-READS.
Counter type: Incrementing.
ELAPSED-BUSY-TIME
Time the process spent executing the measured SQL statement.
If REPORT RATE is on, the output value is the percent of time busy during the interval.
You can calculate the average elapsed time for each call by dividing the ELAPSED-BUSY-TIME
counter value by the CALLS counter value.
Counter type: Elapsed.
ELAPSED-RECOMPILE-TIME
Time the process spent recompiling this statement.
Counter type: Elapsed.
ELAPSED-SORT-TIME
Time spent by the process on sorts for this statement.
Counter type: Elapsed.
ESCALATIONS
Number of times a record lock was escalated to a file lock.
Counter type: Incrementing.
LOCK-WAITS
Number of times this statement waited for a lock request.
Counter type: Incrementing.
MESSAGE-BYTES
Number of message bytes sent for this statement by the system. This counter accumulates the number
of bytes sent for the messages reported by the MESSAGES counter.
In G-series and earlier RVUs, this is a 32-bit counter. In H-series and J-series RVUs, it is a 64-bit
counter.
In G-series RVUs, the MESSAGE-BYTES-F field is a 64-bit version of MESSAGE-BYTES.
Counter type: Accumulating.
MESSAGES
Number of messages sent by the system on behalf of this statement, including messages sent by
the file system to the disk process and messages sent by the SQL executor to the SQL compiler for
recompiles.
In G-series and earlier RVUs, this is a 32-bit counter. In H-series and J-series RVUs, it is a 64-bit
counter.
In G-series RVUs, the MESSAGES-F field is a 64-bit version of MESSAGES.
Counter type: Incrementing.
RECOMPILES
Number of times the statement was recompiled.
Counter type: Incrementing.
350 Entities and Counters