IBM Support

IT24129: DB2 MAY DEADLATCH DURING AN INSERT INTO AN ITC TABLE WHILE THEREARE 2 OR MORE OTHER CONCURRENT IUD TRANSACTIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • B2 may run into a deadlatch when appending new blocks for an ITC
    table (during an insert) while there are 2 or more other
    concurrent transaction. This problem can happen if there is a
    user index on the ITC table and if one of the other transactions
    running parallel to the insert has an index fetch.
    
    If the error occurs, we should see the following stack:
    
    
    -------Frame------ ------Function + Offset------
    0x0900000000112F14 thread_wait + 0x94
    0x090000002C940164 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
    0x6E4
    0x090000002C940864 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x84
    0x090000002D6677CC
    IPRA.$sqlbFindPageInBPOrSim__FP11SQLB_FIX_CBiUlP15SQLB_BufferPoo
    l + 0x1ACC
    0x090000002D66355C sqlbfix__FP11SQLB_FIX_CB + 0x55C
    0x090000002E713444 sqlifix__FP7SQLI_CBP14SQLI_PAGE_DESCUii +
    0x84
    0x090000002F3E037C sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
    0x31FC
    0x090000002F3E0588
    IPRA.$next_level__FP7SQLI_CBP11SQLI_SDGLOBUsUi + 0x28
    0x090000002F3DD6BC sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
    0x53C
    0x09000000302D4040 IPRA.$sqliCleanupEmptyLeaf__FP7SQLI_CBUi +
    0xE20
    0x09000000302CFEE8 sqliCleanupPages__FP7SQLI_CB + 0x2528
    0x090000002F3D97F0
    sqlidelk__FP8sqeAgentP9SQLD_IXCBP10SQLI_IXPCRP8SQLD_KEY8SQLZ_RID
    UlP16SQLB_OBJECT_DESC + 0xF70
    0x090000002EF00DC4
    sqldVirtualColumnDeleteKey__FP8sqeAgentP13SQLD_DFM_WORK8SQLZ_RID
    UsUl + 0x104
    0x090000002E5B8CE0
    sqldbFindAppendOrEmptyBlock__FP8sqeAgentP13SQLD_DFM_WORKP16SQLD_
    TABLE_CACHET3PUlP8SQLZ_RID + 0xC40
    0x090000002EED7DBC
    IPRA.$sqldCreateAppendCachePagesForMDCTable__FP13SQLD_DFM_WORKP1
    5SQLD_PAGE_CACHEP11SQLB_FIX_CBlPUiP16SQLD_TABLE_CACHET6P16dmsBat
    chCreateCB + 0x1FC
    0x090000002EED1090
    sqldCreateNewAppendCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEUlT
    3PUlP16SQLD_TABLE_CACHET6 + 0x3170
    0x090000002EEDA338
    sqldExtendAppendCache__FP13SQLD_DFM_WORKUlP16SQLD_TABLE_CACHET3
    + 0x1398
    0x090000002EEDE000
    sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
    TABLE_CACHET3 + 0x2A0
    0x090000002E5B5AEC
    sqldb_insertITCRow__FP13SQLD_DFM_WORKP16SQLD_TABLE_CACHET2 +
    0x48C
    0x090000002EE60E94
    sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
    0x2A94
    0x090000002ED700B4
    sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
    oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xD4
    0x09000000331DCBE4 sqlriisr__FP8sqlrr_cb + 0x2C4
    

Local fix

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24129

  • 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-02-20

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

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

  • 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:
27 November 2018