Performance enhancements

The Db2® 11.5.6 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:
The following table lists performance enhancements that have been added to Db2 11.5.6:
Table 1. Performance enhancements in 11.5.6
Enhancement Description
Enhanced set integrity performance

SMP parallelization of not incremental set integrity constraint and referential integrity checking can be enabled in non-MPP environments by setting the DB2_EXTENDED_OPTIMIZATION registry variable with the PRLSI ON option. For more information refer to SET INTEGRITY statement.