——————————————————————————————————————————
File statistics definitions
——————————————————————————————————————————
value, the better. After a reorg, this value will generally be close to 100 -
LRESERV. A value close to 50 or lower is a sign of relatively low
ordered index density and suggests a reorg.
OILEAVS The number of Ordered Index B-tree leaf-level nodes. The number of
Table D pages used for the B-tree leaves.
OILPACT Page number of the Order Index B-tree page which is active.
OINBYTS Number of Ordered Index B-tree entry bytes. .
OINENTR The number of distinct field name = value pairs stored in the Ordered
Index B-tree.
OINODEP Percentage of ordered index node pages that contain data. OINODEP
= 100 * (OINBYTS / OINODES) / PAGESZ. In general, the higher this
value, the better. After a reorg, this value will generally be close to 100 -
LRESERV. A value close to 50 or lower is a sign of relatively low
ordered index density and suggests a reorg. This value will usually be
close to OILEAFP except in the case where there are few leaf nodes per
higher level nodes. This situation would suggest a reorg.
OINODES The number of Ordered Index B-tree nodes. The total number of Table
D pages used for the Ordered Index B-tree.
OPENCTL PUBLIC, PRIVATE or SEMIPUBLIC status of file.
OVFLADD Number of records added to overflow areas in table B. Same as the
Model204 OVFLADD parameter (rate or total).
OVFLDEL Number of records deleted from overflow areas in table B. Same as the
Model204 OVFLDEL parameter (rate or total).
PDCHUNK Number of "chunks" allocated for the procedure dictionary. The
procedure dictionary is allocated in chunks of PDSIZE pages. When an
attempt to store a name in the dictionary fails because all chunks are
full, a new chunk is allocated.
PDPAGES Total number of pages allocated for the procedure dictionary. Equal to
PDCHUNK * PDSIZE.
PDSIZE Procedure Dictionary size.
PDSTRPG Procedure Dictionary Strings per page.
PNDGTIME Number of milliseconds since the last update unit completed that a file's
pages have been waiting to be written. The stat is only accumulated
when DKUPDTWT is non-zero.
——————————————————————————————————————————
44 SirFile User's Guide