Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?

Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?
A . Parallelism for DPSI is disabled
B . The DB2 optimizer will not consider DPSI for access path selection
C . DB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism
D . DB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used

View Answer

Answer: D

Explanation: 0

Specifies that Db2 uses the value that is specified for the PARAMDEG subsystem parameter, instead of PARAMDEG_DPSI, to control the degree of parallelism when DPSI is used to drive parallelism. This is the default value for the field. https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/inst/src/tpc/db2z_ipf_paramdegdpsi.html