Show TOC

Example documentationDATAVOLUMES

 

Use of the system tableSYSINFO.DATAVOLUMES

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.

Activities

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