Measure Reference Manual

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.
catalog, schema, object, partition
(Measure H01 and later PVUs) are ANSI SQL identifiers. When omitted, catalog and
schema fields are resolved by the MEASCOM catalog and schema environment values.
If the name space keywords TABLE or INDEX are omitted, TABLE is the assumed default.
Wildcard syntax is:
TABLE [[catalogC.]schemaS.]tableT – all partitions in tableT
INDEX [[catalogC.]schemaS.]indexI – all index partitions in indexI
SCHEMA [catalogC.]schemaS – all objects in schemaS
CATALOG catalogC – all objects in catalogC
CATALOG * - all objects visible on the node
\system-name
is the name of the system executing the opener process. To indicate all systems, use an
asterisk (*). The default is to all systems, unless cpu and pin are specified, in which case,
the default is the local system.
cpu
is the number of the CPU on which the opener process is running. The default is all CPUs.
Use cpu and pin to specify the owner of the opener process.
pin
is the process identification number of the opener process. To indicate all processes, use
an asterisk (*). The default is all processes.
DDL Record for DISCOPEN Entities (ZMS Style)
The ZMS Style DDL record for DISCOPEN entities is supported on Measure G11 and later PVUs.
The fields included in BRIEF reports are in boldface type.
ID Fields DDL Definition
DEFINITION zmsdopen-id.
02 opener-cpu type binary 16 unsigned.
02 opener-pin type binary 16 unsigned.
02 ocb-number type binary 16 unsigned.
02 file-type type binary 16 unsigned.
02 opener-system-name type character 8.
02 file-name.
03 volume type character 8.
03 subvol type character 8.
03 filename type character 8.
02 device-name type character 8.
02 storage-pool type character 8.
02 file-name-MID.
03 PATHID type character 24.
03 CRVSN type character 6.
02 record-type type binary 16 unsigned.
end
Counter Fields DDL Definition
02 driver-input-calls type binary 64.
02 driver-output-calls type binary 64.
02 cache-hits type binary 64.
02 cache-write-hits type binary 64.
02 block-splits type binary 64.
210 Entities and Counters