Object documentationFILES Locate this document in the navigation structure

 

The system table SYSINFO.FILES describes all internal database files except for LOB 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)

File type (TABLE | INDEX | FIXED OBJECT | VARIABLE OBJECT | KEYED OBJECT | KEYED OBJECT INDEX | SHORT COLUMN FILE | <internal_file_type_for_temporary_files> | UNKNOWN | <other_file_types>)

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, 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 this 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 LOB values of the table (KB)

0, if the file is not a table

NULL, if LOBSIZE has not yet been determined

CLUSTERED

CHAR(3)

Specifies whether data pages of the file are considered for storage in clusters (YES | NO)

This means that the entire file is 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)

PACKEDNUMBERCOLUMNS

CHAR(3)

Specifies whether numeric values are stored in a space-saving format (YES | NO)

PACKEDUNICODECOLUMNS

CHAR(3)

Specifies whether columns with the UNICODE code attribute are stored in a space-saving format (YES | NO)

More Information

SYSUPDATECOUNTERWANTED

Concepts of the Database System, Logical Access Structures