FILEDIRECTORIES
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.
|
SESSION ID |
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 (Database-Internal)