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