Use of the system tableSYSINFO.DATAVOLUMES
You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB an: Logging On to a Database.
You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview
Note the General Instructions for formulating SQL statements.
You can use the system table DATAVOLUMES to determine the following database information, among other things:
Displaying the description and size of the volume
SELECT path, configuredsize
FROM SYSINFO.DATAVOLUMES
Displaying the area available for data and the area used for data of the volume with ID 1
SELECT usablesize, usedsize, usedsizepercentage
FROM SYSINFO.DATAVOLUMES
WHERE id = 1