To specify the compression algorithm when you create a table or join index, or alter a table, use the optional BLOCKCOMPRESSIONALGORITHM option. Possible BLOCKCOMPRESSIONALGORITHM values include the following:
| DDL Statement BLOCKCOMPRESSIONALGORITHM Keywords | Result |
|---|---|
| ZLIB | The ZLIB software algorithm is used to compress data blocks. |
| ELZS_H | The ELZS_H hardware algorithm is used to compress data blocks on systems configured with a hardware board. |
| DEFAULT | The compression algorithm is controlled by system settings. |