DATAVOLUMES 
Definition
The system table DATAVOLUMES describes the data volumes in which data is stored.
Structure
DATAVOLUMES
FIXED(5) |
Number of the volume |
|
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 |
USEDCLUSTERAREASIZE |
FIXED(20) |
Area within the cluster area used by data |
PATH |
CHAR(256) |
Name of the volume |