DATAVOLUMES

Definition

The system table DATAVOLUMES describes the data volumes in which data is stored.

Structure

DATAVOLUMES

ID

FIXED(5)

Number of the volume

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

USEDCLUSTERAREASIZE

FIXED(20)

Area within the cluster area used by data

PATH

CHAR(256)

Name of the volume