Db2 DPSI performance enhancements
In Db2 11, you can specify the maximum degree of parallelism for a parallel group in which a data partitioned secondary index (DPSI) is used to drive parallelism.
A DPSI is a nonpartitioning index that is physically partitioned according to the partitioning scheme of the table. When you specify a value of greater than 0 for the new PARAMDEG_DPSI subsystem parameter, you limit the degree of parallelism for DPSIs. When you limit the degree of parallelism, Db2 does not create extraneous parallel tasks that use virtual storage.