The Db2® 11.5.8 release contains performance enhancements that can be enabled to improve the performance of set integrity.
- 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
|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.