Performance enhancements
The Db2® 11.5.8 release contains performance enhancements that can be enabled to improve the performance of set integrity.
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 lists performance enhancements that have been added to Db2
11.5.8:
| Enhancement | Description |
|---|---|
| Enhanced set integrity performance |
SMP parallelization of set integrity constraint and referential integrity checking in non-MPP environments is now available for both incremental and non-incremental set integrity statements. For more information, see SET INTEGRITY statement. |