——————————————————————————————————————————
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
Summary of Contents for SirFile 204
Page 2: ...ii SirFile User s Guide...
Page 4: ...Proprietary Notices iv SirFile User s Guide...
Page 6: ...Contents Index 49 vi SirFile User s Guide...
Page 22: ...Main File Menu 16 SirFile User s Guide...
Page 26: ...File Thresholds Screen 20 SirFile User s Guide...
Page 28: ...File Open Screen 22 SirFile User s Guide...
Page 30: ...File Detail Screen 24 SirFile User s Guide...
Page 34: ...File Tables Screen 28 SirFile User s Guide...
Page 36: ...Messages Screen 30 SirFile User s Guide...
Page 37: ......
Page 52: ...File statistics definitions 46 SirFile User s Guide...
Page 54: ...Date Processing 48 SirFile User s Guide...
Page 56: ...Index 50 SirFile User s Guide...