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.
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 |
Glossary, File Directory