Example documentationDATAVOLUMES Locate this document in the navigation structure


Use of the system tableSYSINFO.DATAVOLUMES


You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: 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


  • Displaying the area available for data and the area used for data of the volume with ID 1

    SELECT usablesize, usedsize, usedsizepercentage


    WHERE id = 1