TS COMPRESSION TYPE field (TS_COMPRESSION_TYPE subsystem parameter)
The TS_COMPRESSION_TYPE subsystem parameter specifies the default compression algorithm to use when Db2 inserts sufficient data into, loads into, or reorganizes table spaces defined to use compression. This also specifies the compression algorithm Db2 uses to compress the SPT01 table space. This subsystem parameter is not used for LOB table spaces.
This subsystem parameter applies only to table spaces or table space partitions that are defined with compression and without an explicit compression algorithm.
| Acceptable values: | FIXED_LENGTH, HUFFMAN |
|---|---|
| Default: | FIXED_LENGTH |
| Update: | option 14 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM.TS_COMPRESSION_TYPE |
- FIXED_LENGTH
- Db2 uses a fixed-length compression algorithm to perform compression and decompression of data stored in the table space. This is the default setting.
- HUFFMAN
- Db2 uses Huffman compression provided by IBM z14® or later hardware to perform compression and decompression of data stored in the table space. Huffman compression applies only to universal table spaces. All other table space types use fixed-length compression, regardless of the TS_COMPRESSION_TYPE subsystem parameter setting.