The system table SYSINFO.FILESYSTEMS describes the existing internal file systems.
ID |
CHAR(8) BYTE |
ID of the internal file system in the database catalog |
NAME |
CHAR(32) |
Local name of the internal file system, which is granted when the file system is imported |
PROVIDERID |
CHAR(255) |
Provider name |
SNAPSHOTID |
FIXED(10,0) |
Snapshot ID |
FILESYSTEMINDEX |
FIXED(2,0) |
Internally granted number of the internal file system, which generally starts at 0 and rises with each granting |
CREATEDATE |
TIMESTAMP |
Date on which the internal file system was imported |
COMMENT |
CLOB |
Comment on the internal file system |