Object documentationDATAVOLUMES Locate this document in the navigation structure

 

The system table SYSINFO.DATAVOLUMES describes the data volumes used.

Structure

‎DATAVOLUMES

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

More Information

Evaluating System Tables, DATAVOLUMES