IBM Support

IT23816: DB2 MAY RETURN STMMSIMULATESORTMERGE ERROR AND NOT BENEFIT FROM SORT MEMORY SIMULATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Any using STMM for Sort tuning                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 Version 11.1 Mod 4 FixPack 4                  *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 Version 11.1 Mod 4 FixPack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23816

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-23

  • Closed date

    2018-12-04

  • Last modified date

    2018-12-04

  • APAR is sysrouted FROM one or more of the following:

    IT23756

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 December 2018