17.10 - CompressionZLIBMethod - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Specifies the specific implementation of the ZLIB algorithm that Vantage will use for block-level compression (BLC)

In addition to the standard ZLIB implementation, Vantage supports the Intel Integrated Performance Primitives library (Intel IPP) with ZLIB for BLC. The CompressionZLIBMethod field determines whether BLC takes advantage of advanced instructions for better compression performance on Intel platforms.

Field Group

Compression

Valid Settings

Setting Description
ZLIB Vantage uses the standard ZLIB library for BLC.
IPPZLIB Vantage uses the Intel IPP library for ZLIB BLC.

If the Intel IPP library is not installed, or an error is encountered, standard ZLIB is used instead.

Default

IPPZLIB

Changes Take Effect

After the DBS Control Record has been written. Changed setting applies to new data added to tables. Compression for existing data is not changed until that data is modified.

Usage Notes

BLC enables data compression at the data block (DB) level of the Teradata file system. Compression reduces the amount of storage required for a given amount of data. The BlockLevelCompression field of DBS Control enables and disables BLC.

Data compressed with IPPZLIB can be uncompressed with either IPPZLIB or standard ZLIB.

Related Information

For more information on... See...
BlockLevelCompression field BlockLevelCompression.
COMPRESS and UNCOMPRESS commands Ferret Utility (ferret).
BLOCKCOMPRESSION query band Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.