——————————————————————————————————————————
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
Содержание SirFile 204
Страница 2: ...ii SirFile User s Guide...
Страница 4: ...Proprietary Notices iv SirFile User s Guide...
Страница 6: ...Contents Index 49 vi SirFile User s Guide...
Страница 22: ...Main File Menu 16 SirFile User s Guide...
Страница 26: ...File Thresholds Screen 20 SirFile User s Guide...
Страница 28: ...File Open Screen 22 SirFile User s Guide...
Страница 30: ...File Detail Screen 24 SirFile User s Guide...
Страница 34: ...File Tables Screen 28 SirFile User s Guide...
Страница 36: ...Messages Screen 30 SirFile User s Guide...
Страница 37: ......
Страница 52: ...File statistics definitions 46 SirFile User s Guide...
Страница 54: ...Date Processing 48 SirFile User s Guide...
Страница 56: ...Index 50 SirFile User s Guide...