The system table SYSINFO.DATAVOLUMES describes the data volumes used.
ID |
FIXED(5) |
Volume ID |
MODE |
CHAR(10) |
Mode of the volume (NORMAL | SEQUENTIAL) |
CONFIGUREDSIZE |
FIXED(20) |
Configured size of the volume (KB) |
USABLESIZE |
FIXED(20) |
Area of the volume that can be used for data (KB) |
USEDSIZE |
FIXED(20) |
Area of the volume used for data (KB) |
USEDSIZEPERCENTAGE |
FIXED(3) |
Area of the volume used as a percentage of the total area that can be used for data |
DROPVOLUME |
CHAR(3) |
Volume is being removed from the database (YES | NO) |
TOTALCLUSTERAREASIZE |
FIXED(20) |
Reserved area (cluster area) at the end of the volume for data stored in clusters (KB) |
RESERVEDCLUSTERAREASIZE |
FIXED(20) |
Area within the cluster area used by clusters (KB) |
USEDCLUSTERAREASIZE |
FIXED(20) |
Area within the cluster area used by data (KB) |
FILESYSTEMID |
FIXED(5) |
ID of the file system |
WRITEABLE |
CHAR(3) |
Specifies whether the volume is writeable (YES | NO) |
PATH |
CHAR(256) |
Name of the volume |
Evaluating System Tables, DATAVOLUMES