Compression and storage enhancements
Db2® 11.5.8 includes compression and storage enhancements to the LOAD utility.
Attention: This mod pack release is currently available for
the following Db2 products:
- Db2 on-premises
- The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS).
- The container micro-service deployment of Db2 on Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
- Db2 for cloud service providers
- Db2 on Cloud
- Db2 Warehouse on Cloud
The following table displays a list of the new compression and storage enhancements in Db2
11.5.8:
| Enhancement | Description |
|---|---|
| Improved performance and compression when populating column-organized tables using the LOAD utility. | The LOAD utility is enhanced to support advanced compression techniques, such as page-based
string compression, and to exploit vectorized processing using SIMD (Single Instruction Multiple
Data). Enabling page-based string compression when populating tables with string data can be very beneficial. Both data compression and the overall performance of the LOAD utility can be significantly improved. No changes are required to the LOAD command syntax or usage scenarios to take advantage of this enhancement. To enable page-based string compression, set the registry variable DB2_COL_STRING_COMPRESSION. |