The Retrieve Member Statistics command retrieves data space activity
that has occurred on a physical file member since the last IPL. The
information provides statistics on the number of reads, updates,
opens, access path builds, etc.
To review several members, you may want to consider the TAA Tool
DSPMBRSTAT.
A typical RTVMBRSTAT command would be:
DCL &READS *DEC LEN(15 0)
.
RTVMBRSTAT FILE(xxx) READS(&READS)
Note that the return variable is a 15 digits. If the number is
larger than 15 digits, all 9s will be returned.
RTVMBRSTAT escape messages you can monitor for
----------------------------------------------
TAA9894 The file is not a PF type
Escape messages from based on functions will be re-sent.
System caveat
-------------
The system does not guarantee the information that is provided.
However, you can rely on the information to provide a general picture
of your data base activity.
Command parameters *CMD
------------------
FILE The qualified name of the physical file to retrieve
the statistics from. The library value defaults to
*LIBL. *CURLIB may also be used.
MBR The member to retrieve the statistics from. *FIRST
is the default.
RTNLIB An optional return variable for the library where
the file was found. This may be helpful if a
special value was used for the qualified name. If
specified, the variable must be declared as *CHAR
LEN(10).
RTNMBR An optional return variable for the member
retrieving the statistics from. This may be helpful
if *FIRST was used for the member name. If
specified, the variable must be declared as *CHAR
LEN(10).
OPENS An optional return variable for the number of opens
that have occurred. If specified, the variable must
be declared as *DEC LEN(15 0).
READS An optional return variable for the number of
records read regardless of whether a physical or
logical file was used. This differs from the
PHYIOREADS parameter. If specified, the variable
must be declared as *DEC LEN(15 0).
UPDATES An optional return variable for the number of record
updates that have occurred. If specified, the
variable must be declared as *DEC LEN(15 0).
DELETES An optional return variable for the number of record
deletes that have occurred. If specified, the
variable must be declared as *DEC LEN(15 0).
ADDS An optional return variable for the number of record
additions that have occurred. If specified, the
variable must be declared as *DEC LEN(15 0).
PHYIOREADS An optional return variable for the total number of
physical read requests. The READS parameter is the
number of records read regardless of whether a
physical or logical file was used. A read to a
physical or logical file may not result in any
physical reads to the data base. If specified, the
variable must be declared as *DEC LEN(15 0).
APBLDS An optional return variable for the number of access
path builds or rebuilds that have occurred. If
specified, the variable must be declared as *DEC
LEN(15 0).
CLEARS An optional return variable for the number of clears
that have occurred such as CLRPFM. If specified,
the variable must be declared as *DEC LEN(15 0).
COPIES An optional return variable for the number of data
space copies that have occurred. A data space copy
would be caused by a function such as CPYF
FROMRCD(1) COMPRESS(*NO) which causes large blocks
of records to be read. If specified, the variable
must be declared as *DEC LEN(15 0).
REORGZ An optional return variable for the number of
reorganizations that have occurred such as RGZPFM.
If specified, the variable must be declared as *DEC
LEN(15 0).
Restrictions
------------
The system does not guarantee the information that is provided.
Because the command returns variables, it can only be used in a CL
program.
A maximum of 15 digits will be returned for each count. If the value
exceeds 15 digits, the value returned is all 9s.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKOBJ3 Check object 3
CVTBIN8 Convert binary 8
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
RTVMBRSTAT *CMD TAAMBRM QATTCMD
TAAMBRMC *PGM CLP TAAMBRMC QATTCL
|
