Filter
Top Products
——————————————————————————————————————————
File statistics definitions
——————————————————————————————————————————
FCTB Total number of pages in the disk buffer pool currently occupied by FCT
pages from the database file.
FCTM Total number of pages in the disk buffer pool currently occupied by
modified FCT pages from the database file. These pages must be
written to disk before they can be flushed from the buffer pool.
FIFLAGS Summed hex value representing file status detail. Valid settings are
sums of the following values:
X'80' - Group index entry required (sorted files).
X'40' - Table B appends page full.
X'20' - Currently active Table D inversion page
full.
X'10' - Field level constraints (file has at least
one field with a UNIQUE attribute).
X'08' - New Table C logic for initial property
entry.
X'04' - Ordered Index list page full.
X'01' - File is post release 3.16.
FILEORG Summed hex value representing the organization of Table B. Valid
settings are sums of the following values:
X'40' - File skewing is enabled.
X'20' - Unordered file.
X'08' - Hash key file.
X'04' - Reuse Record Number file (RRN).
X'02' - Sort or hash key required in every record.
X'01' - Sorted file.
X'00' - Entry order file.
FISTAT The current value of the database file's status byte. Same as the
Model204 FISTAT parameter. Values can be summed:
X'40' - File might be logically inconsistent.
X'20' - File is in deferred update mode.
X'10' - File has been recovered.
X'08' - File is full.
X'02' - File is physically inconsistent.
X'01' - File is not initialized.
Model204 FISTAT parameter.
FOPT Summed hex value representing file options, as follows:
X'80' - Prohibit statement numbers in procedures.
X'40' - Prohibit statement labels in procedures.
X'08' - Append-first mode in RDFS file.
X'02' - Disable lock pending updates.
X'01' - Disallow new field name definitions.
X'00' - Allow labels and statement numbers in
procedures.
——————————————————————————————————————————
SirFile User's Guide 41