Measure Reference Manual

PROGRAM-FILE-NAME-MID
Internal format representation of an OSS file pathname. PROGRAM-FILE-NAME-MID has two
subfields:
is an internal format representation of an OSS file pathname. For non-OSS
files, the field contains zeros.
PATHID
is a creation version serial number that identifies a unique instance of an
OSS file. For non-OSS files, the field contains zeros.
CRVSN
RUN-UNIT
(ZMS Style only) Left-justified external-format ANSI SQL name. The field is defined as 784 characters
(rounded up for alignment reasons), but the length of the actual name is reported in RUN-UNIT-LEN.
Remaining characters are initialized with zeros.
RUN-UNIT-LEN
(ZMS Style only) Length, in bytes, of the external-format ANSI SQL name stored in the RUN-UNIT
field. The maximum value is 783.
STATEMENT-INDEX
Statement index number (0-255) within the specified run unit. These numbers correspond to the
section location table (SLT) index numbers on compiler listings. Use the SLT index to correlate the
STATEMENT-INDEX number with the corresponding EXEC SQL statement in the source code.
To determine the SLT index number for each SQL statement, use the SQLMAP option of the SQL
compiler directive. The SQLMAP option causes the SQL map to appear at the end of the listing.
The SQL map is a table that shows the SLT index number for each SQL statement, along with the
source file name and the line number.
For more information, see the SQL/MP programming manual for the language you are using.
USERID
Process accessor ID of the measured process.
VERSION
The record version: 0, 1, 2 = not used. 3 = G11 PVU.
Common and ZMS Style Only Counter Field DDL Definitions for SQLSTMT Entities
These counter fields are used in both styles of DDL records. Fields that are used in ZMS Style DDL
records only are noted.
Fields are listed alphabetically.
CALLS
Number of times the measured SQL statement was executed.
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 CALLS-F field is a 64-bit version of CALLS.
Counter type: Incrementing.
DISC-READS
Number of physical disk reads performed for this statement. If the REPORT RATE value is on, the
rate is disk reads for each second.
SQLSTMT 349