Measure Reference Manual

◦ A file’s extent size exceeds 65535 pages.
◦ A format 2 file is explicitly requested at creation.
• In Measure G09 and later PVUs, the DISKFILE entity supports the use of OSS file pathnames
as follows:
◦ The directory information in the OSS PATHID is ignored for DISKFILE usage of OSS file
pathnames.
◦ Only one DISKFILE record exists for a file despite the number of accesses made.
◦ Any valid pathname that leads to the file can be used.
◦ The use of directory names to indicate a set of DISKFILE records is not supported.
◦ If you must measure transient DISKFILE records for OSS files, specify them using the
Guardian file name wild-card conventions; for example:
– $*.*.*
– $device.*.*
– *.ZYQnnnnn.
◦ OSS PATHID and CRVSN information is not included in records returned by
MEASREADACTIVE. To obtain OSS file pathnames that correspond to a particular DISKFILE
record, use MEASLISTPNAME. This translation produces a warning that a CRVSN was
not specified. However, you can ignore this warning because the translation is for a value
from an active record.
• In Measure G11 and later PVUs, ANSI SQL names appear in displays.
Example
The report output for the DISKFILE entity includes the ANSI SQL name for files that have an ANSI
SQL name.
Diskfile $DATA.ZSD12345.Z1234567 File Format x
ANSI SQL Name ‘TABLE Catalog_12.Schema_45.Table_56 PARTITION Partition_78’
Device Name $DATA Pool
Local CPU 0 File Type Key Sequenced File Code 550
Format Version: H01 Data Version: H01 Subsystem Version: 1
Local System \HURTS From 12 Jan 2003, 19:35:28 For 46.9 Seconds
------------ File ----------------------------------------------------------
Open-Qtime 72.11 ms Transient-Opens
Starting-EOF Ending-EOF
Extent-Allocations File-Growth-Ratio
------------ Requests ------------------------------------------------------
Lockwait-Time Requests 3 #
Max-Lockwait-Time Requests-Blocked
Lock-Timeouts Lock-Bounces
------------ Logical I/O ---------------------------------------------------
Cache-Read-Hits 2 # Cache-Write-Hits
Block-Splits Cache-Write-Cleans
Driver-Input-Calls 2 # Driver-Output-Calls
DBIO-Input-Calls DBIO-Output-Calls
------------ SQL -----------------------------------------------------------
SQL-Inserts
SQL-Updates SQL-Deletes
SQL-Starting-Rows SQL-Ending-Rows
------------ Open System Services ------------------------------------------
OSS-Cache-Callbacks OSS-Callback-Writes
OSS-Block-Writes OSS-Block-Write-Bytes
226 Entities and Counters