FILES

Definition

The system table FILES describes all internal database files except for LONG files.

Structure

FILES

FILEID

CHAR(8) BYTE

ID of the file

SESSIONID

FIXED(10)

ID of the database session in which temporary files were created
NULL for persistent files

ROOT

FIXED(10)

Page number of the file root

TYPE

CHAR(20)

Type of file (TABLE | INDEX | FIXED OBJECT | VARIABLE OBJECT | KEYED OBJECT | KEYED OBJECT INDEX | SHORT COLUMN FILE | internal file type for temporary files | UNKNOWN)

PRIMARYFILEID

CHAR(8) BYTE

ID of the corresponding table if the file is of the type SHORT COLUMN FILE or INDEX or
ID of the corresponding KEYED OBJECT if the file is of the type KEYED OBJECT INDEX or
NULL if the file is of any other type

FILESTATE

CHAR(20)

File status (OK | DELETED | BAD | READ ONLY | UNKNOWN)

ENTRYCOUNT

FIXED(20)

Number of entries in the file
NULL if there are no entries or if ENTRYCOUNT has not yet been determined

TREEINDEXSIZE

FIXED(20)

Space that is occupied by index pages of the file (KB)
NULL if the file has no index pages or if TREEINDEXSIZE has not yet been determined

TREELEAVESSIZE

FIXED(20)

Space that is occupied by the leaf pages of the file (KB)
NULL if TREELEAVESIZE has not yet been determined

LOBSIZE

FIXED(20)

Space that is occupied by LONG values of the table (KB)
NULL if the file is not a table or if LOBSIZE has not yet been determined

CLUSTERED

CHAR(3)

Specifies whether data pages in the file are considered for storage in clusters (YES | NO)
This does not mean that the file will be completely stored in clusters.

DYNAMIC

CHAR(3)

Specifies whether a simplified overflow/underflow handling is applied to B* tree pages (YES | NO)

PACKED

CHAR(3)

Specifies whether data records of the file are stored in a space-saving format (YES | NO)

See also:

SYSUPDATECOUNTERWANTED

Concepts of the Database System, Logical Access Structures