Filter
Top Products
——————————————————————————————————————————
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