IBM Support

IT22110: CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES DURING HASH TABLE JOIN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Instance may crash with a stack similar to the following:
    
    -------Frame------ ------Function + Offset------
    0x000000000000F4E4 ?unknown + 0x0
    0x090000003303EF7C
    appendPayload__Q3_7ibm_cde5query12ExtraPayloadXTlSP0_FPCQ3_7ibm_
    cde5types7IntegerXTlSP0_CUlT2 + 0x48
    0x09000000325BC4B4
    formCompactHashTable__Q3_7ibm_cde5query18RegularLPHashTableXTlTl
    SP0SP1_Hll_UibCP13SQLO_MEM_POOL_Q2_3std8auto_ptrXTQ3_7ibm_cde5qu
    ery9CompactHTXTlTlTlTlSP1SP1SP1__ + 0x1474
    0x09000000325BDA88
    formCompactHashTable__Q3_7ibm_cde5query14JoinProbeTableXSP0SP1SP
    100SP1_FUibCP13SQLO_MEM_POOL + 0xF4
    0x09000000325A7B48
    managePart__Q3_7ibm_cde5query13JoinSpillInfoFUlN21Rl + 0x2F8
    0x09000000323B9814
    manageSpill__Q3_7ibm_cde5query13JoinSpillInfoFUlQ4_7ibm_cde5quer
    y13JoinSpillInfo14JoinSpillPhaselT1 + 0x44
    0x09000000324132B4
    loadPart__Q3_7ibm_cde5query13JoinSpillInfoFUlRQ3_7ibm_cde5types9
    BitStringbT1UiRUiRQ3_7ibm_cde8services11ScopedMutex + 0xA4C
    0x0900000032415BF8
    reserveAgentPart__Q3_7ibm_cde5query13JoinSpillInfoFUlRQ3_7ibm_cd
    e5types9BitStringT1RUlRUiT5 + 0x11FC
    0x0900000031F82F48
    reserveAgentPartGroup__Q3_7ibm_cde5query13JoinSpillInfoFUlRQ3_7i
    bm_cde5types9BitStringT1RUl + 0x550
    0x0900000031F80DA4
    loadWorkunitsAndPartGroup__Q3_7ibm_cde5query23GetJoinPayloadEval
    uatorFPQ3_7ibm_cde5query5Queue + 0x64C
    0x090000003109E7AC
    processInputsSynchronously__Q3_7ibm_cde5query23GetJoinPayloadEva
    luatorFv + 0x64C
    
    Crash is data dependent and does not always occur.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 iFix001 or higher       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 2 Fix Pack 2 iFix001
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22110

  • 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

    2017-08-23

  • Closed date

    2017-10-11

  • Last modified date

    2017-10-11

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

    IT20383

  • 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

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

Document Information

Modified date:
29 June 2020