Measure Reference Manual
02 open-time type binary 64.
end
DDL Record Description Fields
RECORD zmssqlp. FILE is "zmssqlp" ENTRY-SEQUENCED.
02 hdr type zmsheader.
02 ctr type zmssqlp-ctrs.
02 id type zmssqlp-id.
end
DDL Record for SQLPROC Entities (Legacy Style)
The Legacy Style DDL record for SQLPROC entities will not change after the Measure G10 PVU.
The fields included in BRIEF reports are in boldface type.
RECORD sqlproc. FILE is "sqlproc" ENTRY-SEQUENCED.
.
.
.
(error, time items, and measurement identification items;
see Common Entity Header Fields (page 144))
.
.
.
* entity identification items:
02 pin type binary 16 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 priority type binary 16 unsigned.
02 userid.
03 group type binary 8 unsigned.
03 user type binary 8 unsigned.
* counter value items:
02 sql-obj-recompiles type binary 16 unsigned.
02 sql-obj-recompile-time type binary 64.
02 sql-stmt-recompiles type binary 16 unsigned.
02 sql-stmt-recompile-time type binary 64.
02 sql-newprocesses type binary 16 unsigned.
02 sql-newprocess-time type binary 64.
02 opens type binary 16 unsigned.
02 open-time type binary 64.
02 creatorid.
03 group type binary 8 unsigned.
03 user type binary 8 unsigned.
* new entity identification items for D10:
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.
* SMS changes:
02 device-name type character 8.
* new identifiers for OSS file pathname support:
02 osspid type binary 32 unsigned.
02 program-file-name-mid.
03 pathid type character 24.
03 crvsn type character 6.
* New identifiers for NetBatch Job Control:
02 GMOM.
03 GMOM-node type binary 16 unsigned.
03 GMOM-cpu type binary 16 unsigned.
03 GMOM-pin type binary 16 unsigned.
338 Entities and Counters