Object documentationFILEDIRECTORIES Locate this document in the navigation structure

 

The system table SYSINFO.FILEDIRECTORIES describes all internal file directories, that is, the general directory as well as the local directories of all database sessions.

Structure

FILEDIRECTORIES

SESSIONID

FIXED(10)

ID of the database session to which the local file directory belongs

NULL for the general file directory

MAXUSEDFILEID

CHAR(8) BYTE

Largest assigned file number

- for a local file directory, file number for temporary files

- for a general file directory, file number for persistent files

ENTRYCOUNT

FIXED(10)

Number of entries in this file directory

CACHEENTRYCOUNT

FIXED(10)

Number of entries buffered in the cache of the local file directory

NULL for the general file directory

HASHTABLESLOTCOUNT

FIXED(10)

Number of slots in the hash table of the file directory

USEDHASHTABLESLOTCOUNT

FIXED(10)

Number of used slots in the hash table of the file directory

MAXHASHTABLECHAINENTRYCOUNT

FIXED(10)

Longest hash chain in the hash table of the file directory since the last enlargement of the hash chain

RESIZEHASHTABLECOUNT

FIXED(10)

Number of times the hash table had to be resized

USEDPAGECOUNT

FIXED(10)

Number of occupied data pages for the general file directory

NULL for the local file directories

STATISTICSDELTACOUNT

FIXED(10)

Number of file directory entries that were changed after a savepoint

CURRENTSTATISTICSDELTACOUNT

FIXED(10)

Number of file directory entries that were changed after the current savepoint

More Information

Glossary, File Directory (Database-Internal)