ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Reports information about space available for a dbspace, transaction log, transaction log mirror, and/or temporary file.
sa_disk_free_space ( [ string ] )
string can be one of dbspace-name, log, mirror, or temp.
If there is a dbspace called log, mirror, or temp, you can prefix the keyword with an underscore. For example, use _log to get information about the log file when a dbspace exists called log.
If string is not specified or is null, then the result set contains one row for each dbspace, plus one row for each of the transaction log, transaction log mirror, and temporary file, if they exist. If string is specified, then exactly one or zero rows will be returned (zero if no such dbspace exists, or if "log" or "mirror" is specified and there is no log or mirror file).
DBA authority required
None
The result set has two columns: dbspace or file name; and the number of free bytes on the volume.