March Products 204 User Manual
Page 48
——————————————————————————————————————————
File statistics definitions
——————————————————————————————————————————
FRCVOPT
Summed hex value indicating file recovery options, as follows:
X'80' - Updates not allowed without roll forward
active.
X'40' - Updates not allowed unless checkpointing
active.
X'20' - File does not participate in
checkpointing.
X'10' - Discontinuities not allowed.
X'08' - Transaction backout disabled.
X'04' - File does not take part in roll forward
logging.
X'02' - File does not participate in roll forward.
X'01' - Transaction boundaries are ignored when
applying roll forward updates.
FREESIZ
Number of unassigned pages in the database file. Same as the
Model204 FREESIZE parameter.
FVFPG
Number of Table A pages used for storing the values from "few valued"
coded
fields.
HIGHSRT
Record number containing the highest sort key. Same as the Model204
HIGHSORT
parameter.
IXADD
Index entries added to tables C and D, including attempts to add
duplicates (rate or total).
IXDEL
Index entries deleted from tables C and D (rate or total).
MODPAGA
Total number of pages in the disk buffer pool currently occupied by
modified table A pages from the database file. These pages must be
written to disk before they can be flushed from the buffer pool.
MODPAGB
Total number of pages in the disk buffer pool currently occupied by
modified table B pages from the database file. These pages must be
written to disk before they can be flushed from the buffer pool.
MODPAGC
Total number of pages in the disk buffer pool currently occupied by
modified table C pages from the database file. These pages must be
written to disk before they can be flushed from the buffer pool.
MODPAGD
Total number of pages in the disk buffer pool currently occupied by
modified table D pages from the database file. These pages must be
written to disk before they can be flushed from the buffer pool.
MODPAGE
Total number of pages in the disk buffer pool currently occupied by
modified pages from all tables in the database file. These pages must
be written to disk before they can be flushed from the buffer pool. Equal
to MODPAGA + MODPAGB + MODPAGC + MODPAGD + MODPAGF
+
MODPAGL.
——————————————————————————————————————————
42
SirFile User's Guide