Measure Reference Manual

"pname"
(Measure G09 and later PVUs) is either a fully qualified or partial OSS file pathname. An
OSS file pathname that does not begin with a slash (/) is considered to be a partial
pathname and is expanded by prefacing it with the current setting for OSSPATH. 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 SQLPROC Entities (ZMS Style)
The ZMS Style DDL record for SQLPROC entities is supported in Measure G11 and later PVUs.
The fields included in BRIEF reports are in boldface type.
ID Fields DDL Definition
DEFINITION zmssqlp-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.
02 process-name type character 8.
02 program-file-name.
03 volume type character 8.
03 subvol type character 8.
03 filename type character 8.
02 osspid type binary 32 unsigned.
02 ancestor-cpu type binary 16 unsigned.
02 ancestor-pin type binary 16 unsigned.
02 ancestor-sysname type character 8.
02 ancestor-process-name type character 8.
02 device-name type character 8.
02 program-file-name-MID.
03 PATHID type character 24.
03 CRVSN type character 6.
02 reserved-1 type character 2.
02 GMOM.
03 GMOM-node type binary 16 unsigned.
03 GMOM-cpu type binary 16 unsigned.
03 GMOM-pin type binary 16 unsigned.
03 GMOM-jobid type binary 16 unsigned.
02 GMOM-full-id type binary 64
redefines GMOM.
02 GMOM-sysname type character 8.
02 GMOM-process-name type character 8.
end
Counter Fields DDL Definition
DEFINITION zmssqlp-ctrs.
02 sql-obj-recompiles type binary 64.
02 sql-obj-recompile-time type binary 64.
02 sql-stmt-recompiles type binary 64.
02 sql-stmt-recompile-time type binary 64.
02 sql-newprocesses type binary 64.
02 sql-newprocess-time type binary 64.
02 opens type binary 64.
SQLPROC 337