DB2 FOR LUW / DB2FORLUW / A50 - DB2

This is a sort simulation problem where sort simulation has
inconsistent "minimum" size requests, resulting in the
determined minimum size being insufficient to drive simulation,
and returning the stmmSimulateSortMerge error messages of the
type: "ERROR simulation of real configuration has failed". This
can result in STMM not benefiting from sort memory simulations
in certain circumstances.

Typical error messages in the db2diag.log:

2017-04-21-11.07.27.800785-300 I228272697E712        LEVEL:
Warning
PID     : 7242                 TID : 140347095115520 PROC :
db2sysc 0
INSTANCE: db2admin             NODE : 000            DB   : NOW
APPHDL  : 0-204                APPID:
192.168.0.1.39078.170421112538
AUTHID  : DB2ADMIN             HOSTNAME: db2server
EDUID   : 127                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmSimulateSortMerge, probe:3355
MESSAGE : ZRC=0x87AE0165=-2018639515=STMM_SEVERE_ERROR
          "Severe error encountered in self tuning memory
manager"
DATA #1 : String, 91 bytes
ERROR simulation of real configuration has failed - not
reporting benefit for this operator

2017-04-21-11.07.28.232759-300 I228273410E712        LEVEL:
Warning
PID     : 7242                 TID : 140347095115520 PROC :
db2sysc 0
INSTANCE: db2admin             NODE : 000            DB   : NOW
APPHDL  : 0-204                APPID:
192.168.0.1.39078.170421112538
AUTHID  : DB2ADMIN             HOSTNAME: db2server
EDUID   : 127                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmSimulateSortMerge, probe:3355
MESSAGE : ZRC=0x87AE0165=-2018639515=STMM_SEVERE_ERROR
          "Severe error encountered in self tuning memory
manager"

****************************************************************
* USERS AFFECTED:                                              *
* Any using STMM for Sort tuning                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Fixpack 10                                        *
****************************************************************

not known / see Local fix

forerunner  : 
follow-up : IT23816 

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

17.01.2018
13.07.2018
13.07.2018