Measure Reference Manual

index
is the index number of the statement to be measured. If omitted, all current indexed
statements are measured.
disk-filename
is the name of an object file that contains SQL code to be measured. This file must be the
object file of a running process. Specify the disk-file name as:
{ [ \system.]$device.subvol.filename[:crvsn]}
{ subvol.filename[:crvsn] }
{ filename[:crvsn] }
\system
is the system name. To indicate all devices, use an asterisk (*). The default is the current
default system.
$device
is the volume (device) name. To indicate all volumes, use an asterisk (*). The default is
the current default volume.
subvol
is the subvolume name. To indicate all subvolumes, use an asterisk (*). The default is
the current default subvolume.
filename
is the object file name. To indicate all files (except temporary files), use an asterisk (*).
:crvsn
(Measure G09 and later PVUs) is the timestamp, creation version serial number (CRVSN),
or file name extension necessary to form a unique file name. Use this option to guarantee
file name uniqueness. The CRVSN is available from the Measure report and the
LISTGNAME command.
"pname"
(Measure G09 and later PVUs) is either a fully qualified or partial OSS file pathname. To
get a fully qualified and valid OSS file pathname, combine pname with the current OSSPATH
setting. If the OSS file pathname does not begin with a backslash (/), expand it by putting
the current setting for OSSPATH in front of the backslash. An OSS file pathname that begins
with /G is not supported, use the Guardian file name instead.
NOTE: OSS file pathnames are case-sensitive and must be specified within double
quotation marks (" "). Valid OSS file pathnames can refer to specific files or to a set of files
within a specific directory. If a directory is specified, only files in that directory are included.
Files in directories subordinate to the specified directory are not included.
DDL Record for SQLSTMT Entities (ZMS Style)
The ZMS Style DDL record for SQLSTMT entities is supported in Measure G11 and later PVUs.
The fields included in BRIEF reports are in boldface type.
ID Fields DDL Definition
DEFINITION zmssqls-id.
02 pin type binary 16 unsigned.
02 priority type binary 16 unsigned.
02 userid.
03 group type binary 8 unsigned.
03 user type binary 8 unsigned.
02 creatorid.
03 group type binary 8 unsigned.
03 user type binary 8 unsigned.
344 Entities and Counters