DATAVOLUMES
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