Contents Index sa_disable_auditing_type sa_enable_auditing_type

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_disk_free_space system procedure


Function 

Reports information about space available for a dbspace, transaction log, transaction log mirror, and/or temporary file.

Syntax 

sa_disk_free_space ( [ string ] )

Parameters 

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).

Permissions 

DBA authority required

Side effects 

None

Description 

The result set has two columns: dbspace or file name; and the number of free bytes on the volume.


Contents Index sa_disable_auditing_type sa_enable_auditing_type