Measure Reference Manual

Example
The report output for the DISCOPEN entity includes the ANSI SQL name for files that have an ANSI
SQL name. Here is an example:
Disc File Open $DATA.ZSD12345.Z1234567
ANSI SQL Name ‘TABLE Catalog_12.Schema_45.Table_56 PARTITION Partition_78’
Device Name $DATA Pool
File Type Key Sequenced Local CPU 0
Opener Process: System \HURTS CPU 0 Pin 285
Format Version: H01 Data Version: H01 Subsystem Version: 1
Local System \HURTS From 12 Jan 2003, 19:35:28 For 46.9 Seconds
------------ Requests ------------------------------------------------------
Lockwait-Time Requests 3 #
Max-Lockwait-Time Requests-Blocked
Lock-Timeouts Lock-Bounces
------------ Logical I/O ---------------------------------------------------
Cache-Hits 6 # Cache-Write-Hits
Block-Splits Cache-Write-Cleans
Driver-Input-Calls 6 # Driver-Output-Calls
DBIO-Input-Calls DBIO-Output-Calls
------------ SQL -----------------------------------------------------------
SQL-Operation-Time
DISKFILE
The DISKFILE entity measures the I/O operations performed by all opener processes on a specified
disk file (physical file access). DISKFILE uses FCB to measure openers and creates one counter
record for each measured file. The DISKFILE entity type does not track individual opener processes
unless a file closes and reopens during a measurement.
In Measure G09 and later PVUs, the DISKFILE entity supports the use of OSS file pathnames in
place of Guardian file names. It displays OSS file pathnames in DISKFILE reports and provides
direct mapping between external structured records and the new OSSNAMES structured record
output. Although many OSS file pathnames refer to a specific disk file, only one DISKFILE record
exists for a file. Using any valid name retrieves the desired record. In reporting the record, all valid
names that refer to the record are listed.
In Measure G11 and later PVUs, ANSI SQL names appear in displays.
In Measure H01 and later PVUs, MEASCOM accepts ANSI SQL names in a DISKFILE entity
specification.
D-SeriesTopic
217Entity specification syntax for DISKFILE entities
218DDL records for DISKFILE entities
221DDL field definitions for DISKFILE entities
225Usage notes for DISKFILE entities
226Example of DISKFILE measurement
Entity Specification Syntax for DISKFILE Entities
To describe DISKFILE entities:
DISKFILE entity-spec [,entity-spec] ...
DISKFILE
collects information about physical and logical access to a specified file.
entity-spec
is specified as:
DISKFILE 217