CompressionZLIBMethod - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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

In addition to the standard ZLIB implementation, Teradata Database 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 Teradata Database uses the standard ZLIB library for BLC.
IPPZLIB Teradata Database 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 Database 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 Topics

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.