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 | SQL Data Definition Language - Syntax and Examples. |