Workload Capping and SMP degree *OPTIMIZE change

When DB2® Symmetric Multiprocessing (SMP) is used with a value of *OPTIMIZE, the query optimizer calculates the maximum degree that can be used based on the number of processing units that are assigned to the partition. The conversion formula is that 100 units is equivalent to 1 whole processor. When workload capping was in effect, the optimizer was incorrectly multiplying the workload capping value by the number of SMT threads supported for the processor and then using the smaller of the number of whole processors and the calculated workload capping threads. To be consistent with how the degree is calculated for *OPTIMIZE, the optimizer will now use the smaller of the specified workload capping value and the number of whole processors. The number of SMT threads is no longer considered for *OPTIMIZE. The workload capping calculations for SMP of *MAX and *NBRTASKS are unchanged and include the number of SMT threads per processor.