DB2 FOR LUW / DB2FORLUW / B10 - DB2

The issue addressed in this APAR has the same symptom to APAR
IT16615.  Refer to IT16615 for more details:
http://www-01.ibm.com/support/docview.wss?uid=swg1IT16615

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************

1. Same as APAR IT16615, use a fixed value for sortheap, instead
of letting STMM tuning it. Check db2diag.log for sortheap tuning
entries and choose a value at the upper end in order to avoid
having too low sortheap memory.

2.Set the problem query degree to 1 using optimizer guideline:
 
There may be performance impact for this query since setting
degree to 1 is taking away the performance advantage of SMP.

not known / see Local fix

forerunner  : IT24045 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.11.2018
27.11.2018
27.11.2018