Reports information about space available for a transaction log, transaction log mirror, and/or temporary file.
sa_disk_free_space( [ p_dbspace_name ] )
Specify SYSTEM to get information about the main database file, TEMPORARY or TEMP to get information about the temporary file, TRANSLOG to get information about the transaction log, or TRANSLOGMIRROR to get information about the transaction log mirror.
Column name | Data type | Description |
---|---|---|
dbspace_name | VARCHAR(128) | This is the 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. |
If the p_dbspace_name parameter is not specified or is NULL, then the result set contains 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 log or mirror is specified and there is no log or mirror file).
You must have the MANAGE ANY DBSPACE system privilege.
None
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 |