Show TOC

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

Identification of the file

SESSIONID

FIXED(10)

Identification of the database session in which temporary files were created

NULL for persistent files

ROOT

FIXED(10)

Page number of the file root

RECOVERYMODE

CHAR(10)

Recovery mode of the root page (PERMANENT for persistent tables | STATIC for SAP liveCache object files | TEMPORARY for temporary files)

FILESYSTEMID

FIXED(5)

File system identification of the root page (FILESYSTEMID returns the index of the database internal file system/converter the file is stored in. A FILESYSTEMID of 0 means that the file is stored in the default file system/converter.)

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)

CACHE

CHAR(3)

Specifies whether table content data is stored in a separate LRU list in the data cache that is reserved for tables with this attribute (YES | NO). If the content of all tables with the CACHE attribute set fits into this special data cache area then effectively it will never get evicted from the data cache again once it has been loaded.

NOCACHE

CHAR(3)

Specifies whether table content data will be evicted from the data cache right after every access (YES | NO)