Measure Reference Manual
DDL Record for DISKFILE Entities (Legacy Style)
The Legacy Style DDL record for DISKFILE entities will not change after the Measure G10 PVU.
The fields included in BRIEF reports are in boldface type.
The DDL record for G-series DISKFILE entities is identical to the record for D-series DISKFILE entities
except that counters are added to support direct bulk I/O and SQL actions. (Existing I/O counters
such as DRIVER-INPUT-CALLS also include direct-bulk I/O operations.) In addition, new identifiers
have been added for OSS file pathname support.
RECORD diskfile. FILE is "diskfile" ENTRY-SEQUENCED.
.
.
.
(error, time items, and measurement identification items;
see Common Entity Header Fields (page 144))
.
.
.
* entity identification items:
02 FCB-number type binary 16 unsigned.
02 file-name.
03 volume type character 8.
03 subvol type character 8.
03 filename type character 8.
02 file-type type binary 16 unsigned.
02 file-code type binary 16 unsigned.
* counter value items:
02 starting-eof type binary 64.
02 ending-eof type binary 64.
02 transient-opens type binary 32 unsigned.
02 open-qtime type binary 64.
02 open-qlen-max type binary 16 unsigned.
02 driver-input-calls type binary 32 unsigned.
02 driver-output-calls type binary 32 unsigned.
02 cache-read-hits type binary 32 unsigned.
02 cache-write-hits type binary 32 unsigned.
02 cache write-cleans type binary 32 unsigned.
02 requests type binary 32 unsigned.
02 requests-blocked type binary 32 unsigned.
02 lockwait-time type binary 64.
02 max-lockwait-time type binary 64.
02 lock-timeouts type binary 32 unsigned.
02 lock-bounces type binary 32 unsigned.
02 block-splits type binary 32 unsigned.
02 extent-allocations type binary 32 unsigned.
* SMS changes:
02 device-name type character 8.
02 storage-pool type character 8.
* New counters in G05:
02 dbio-input-calls type binary 32 unsigned.
02 dbio-output-calls type binary 32 unsigned.
* New counters in G08:
02 SQL-inserts type binary 32 unsigned.
02 SQL-updates type binary 32 unsigned.
02 SQL-deletes type binary 32 unsigned.
02 ending-rows type binary 32 unsigned.
02 format type binary 16 unsigned.
* New identifiers for OSS file pathname support:
02 file-name-mid.
03 pathid type character 24.
03 crvsn type character 6.
* New counters in G10:
02 OSS-Block-Writes type binary 32 unsigned.
220 Entities and Counters