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 name Data type Description
dbspace_name VARCHAR(128) This is the dbspace name, transaction log file, transaction log mirror file, or temporary file.
free_space UNSIGNED BIGINT The number of free bytes on the volume.
total_space UNSIGNED BIGINT The total amount of disk space available on the drive where the dbspace resides.

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

Permissions

DBA authority

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_name free_space total_space
system 10952101888 21410402304
translog 10952101888 21410402304
temporary 10952101888 21410402304