UncompressReservedSpace - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Specifies the minimum percentage of storage space that must remain available while DBs are uncompressed using the Ferret UNCOMPRESS command. The uncompress operation is terminated at the point where this threshold would be exceeded.

Field Group

Compression

Valid Range

1 through 90%

Default

20%

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

The table undergoing decompression at the time this field value is exceeded may remain in a partially compressed state. This will not affect the functioning of the table or database. To make the table DBs consistent with respect to compression, either issue the Ferret COMPRESS command, or free some storage space, then reissue the UNCOMPRESS command.

Set this field to represent the expected peak amount of required spool space.

Related Topics

For more information on... See...
COMPRESS and UNCOMPRESS commands Ferret Utility (ferret).