beautypg.com

March Products 204 User Manual

Page 47

background image

——————————————————————————————————————————

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