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