Measure Reference Manual

RECORDS-ACCESSED
Number of records accessed by the disk process or file system to evaluate this statement.
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 RECORDS-ACCESSED-F field is a 64-bit version of RECORDS-ACCESSED.
Counter type: Accumulating.
RECORDS-USED
Number of records inserted, updated, deleted, or read by the SQL executor through this statement.
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 RECORDS-USED-F field is a 64-bit version of RECORDS-USED.
Counter type: Accumulating.
SORTS
Number of times an external sort process was invoked for this statement.
Counter type: Incrementing.
TIMEOUTS
Number of times a request timed out. A timeout is caused by either a lock-wait or a congested disk
process or network.
Counter type: Incrementing.
Legacy Style Only ID Field DDL Definitions for SQLSTMT Entities
These ID fields are used in Legacy Style DDL records only.
Fields are listed alphabetically.
FULL-NAME
(Legacy Style only) Left-justified external-format ANSI SQL name. This field is defined as 784
characters, but the length of the actual name is reported in FULL-NAME-LEN. Remaining characters
are undefined.
FULL-NAME-LEN
(Legacy Style only) Length, in bytes, of the external-format ANSI SQL name stored in the FULL-NAME
field. The maximum value is 783.
FULL-NAME-OFFSET
(Legacy Style only) Offset, in bytes, from the beginning of the SQLSTMT record of the FULL-NAME
field.
RUN-UNIT
(Legacy Style only) Name of the procedure that contains the measured SQL statement. For SQL/MX,
if the actual name of the procedure exceeds the 32 characters allowed, a field overflow is reported
in the ERROR field and only the least-significant 31 bytes (preceded by a tilde (~)) are included.
You can obtain the full name from the run-unit-128 field. See DDL Record for SQLSTMT Entities
(Legacy Style) (page 345).
SQLSTMT 351