Measure Reference Manual

RUN-UNIT-128
(Legacy Style only) Name of the SQL/MP procedure or SQL/MX module that contains the measured
SQL statement.
Legacy Style Only Counter Field DDL Definitions for SQLSTMT Entities
These counter fields are used in Legacy Style DDL records only.
Fields are listed alphabetically.
CALLS-F
(G-series, Legacy Style only) Same as CALLS but accommodates larger values (64 bits rather than
32).
DISC-READS-F
(G-series, Legacy Style only) Same as DISC-READS but accommodates larger values (64 bits rather
than 32).
MESSAGE-BYTES-F
(G-series, Legacy Style only) Same as MESSAGE-BYTES but accommodates larger values (64 bits
rather than 32).
MESSAGES-F
(G-series, Legacy Style only) Same as MESSAGES but accommodates larger values (64 bits rather
than 32).
RECORDS-ACCESSED-F
(G-series, Legacy Style only) Same as RECORDS-ACCESSED but accommodates larger values (64
bits rather than 32).
RECORDS-USED-F
(G-series, Legacy Style only) Same as RECORDS-USED but accommodates larger values (64 bits
rather than 32).
Usage Notes for All SQLSTMT Entities
• You do not need to explicitly add the SQLPROC entity for the SQLSTMT entity. When you add
the SQLSTMT entity to a measurement, the corresponding SQLPROC entity is automatically
added for the measured process. You can use the SQLPROC entity to get more information
about the measured SQL process. However, Measure does not automatically add the PROCESS
entity when the SQLSTMT entity is added. If PROCESS entity information is also required, you
must specifically add the PROCESS entity.
• SUBSYSTEM-VERSION for ZMSSQLS records is provided by the SQL/MP or SQL/MX
subsystem.
• When specifying file names, you can use an asterisk as a wildcard, provided that the asterisk
replaces the entire element (volume, subvolume, or file name):
* or $*.*.* means all files.
$vol.*.* means all files in the specified volume.
$vol.subvol.* means all files in the specified subvolume, in the specified volume.
$*.subvol.* means all files in the specified subvolume, in any volume.
$vol.*.file means the specified file, in any subvolume in the specified volume.
352 Entities and Counters