——————————————————————————————————————————
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
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...