Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_disable_auditing_type system procedure Next Page

sa_disk_free_space system procedure


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

Syntax

sa_disk_free_space( [ p_dbspace_name ] )

Arguments
Result set
Column nameData typeDescription
dbspace_nameVARCHAR(128)This is the dbspace name, transaction log file, mirror log file, or temporary file.
free_spaceUNSIGNED BIGINTThe number of free bytes on the volume.
Remarks

If the p_dbspace_name parameter 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 p_dbspace_name is specified, then exactly one or zero rows are returned (zero if no such dbspace exists, or if log or mirror is specified and there is no log or mirror file).

For a list of the names of the pre-defined dbspaces for SQL Anywhere databases, see Pre-defined dbspaces.

Permissions

DBA authority required

Side effects

None

Example

The following example uses the sa_disk_free_space system procedure to return a result set containing information about available space.

CALL sa_disk_free_space( )
dbspace_namefree_space
SYSTEM10952101888
Transaction Log10952101888
Temporary File10952101888