IBM Support

IT27901: INDEX RECLAIM EXTENTS MAY HOLD ALTER TABLE LOCK INDEFINITELY WHILE PROCESSING A LOOP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During an index structure modification (i.e. index page split)
    the index may enter a transient state in which REORG INDEX ...
    RECLAIM EXTENTS may traverse a cycle in the index indefinitely
    causing the REORG INDEX RECLAIM EXTENTS to hang indefinitely.
    
    An Example Stack a snapshot of the reclaim traversing this cycle
    in the index tree
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0900000057C37A34
    IPRA.$sqlbAddPageToDirtyList__FP11SQLB_FIX_CBP8SQLB_BPDb + 0x7F4
    0x0900000057C30D4C
    IPRA.$sqlbFindPageInBPOrSim__FP11SQLB_FIX_CBiUlP15SQLB_BufferPoo
    l + 0x114C
    0x0900000057C2D45C sqlbfix__FP11SQLB_FIX_CB + 0x55C
    0x0900000058CDDE44 sqlifix__FP7SQLI_CBP14SQLI_PAGE_DESCUii +
    0x84
    0x09000000599AAEFC sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
    0x31FC
    0x09000000599AB108
    IPRA.$next_level__FP7SQLI_CBP11SQLI_SDGLOBUsUi + 0x28
    0x09000000599A823C sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
    0x53C
    0x09000000599AB108
    IPRA.$next_level__FP7SQLI_CBP11SQLI_SDGLOBUsUi + 0x28
    0x09000000599A823C sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
    0x53C
    0x09000000599EEAA4 sqliTryToMovePage__FP7SQLI_CB + 0x324
    0x09000000599EDCC8
    sqliReclaimCollocatePages__FP15SQLI_RECLAIM_CB + 0x2E8
    0x09000000599F195C
    sqliReorgReclaimExtents__FP8sqeAgentP8SQLD_TCBUlP17SQLD_CREATEIN
    X_CB + 0x97C
    0x090000005D36B270
    sqldCleanupIndexesAndOrReclaimExtents__FP8sqeAgentP17SQLD_CREATE
    INX_CBUl + 0x950
    0x090000005B0388C4
    IPRA.$sqlrreorg_inx_cleanup_and_or_reclaim__FP8sqlrr_cbP8sqlrg_i
    diP17SQLD_CREATEINX_CBP8sqlrg_pdUsUl + 0x1AA4
    0x090000005B035474
    sqlrreorg_indexes__FP8sqlrr_cbUsT2P8sqlrg_idT2iT6UlPUcT6T9T6C11s
    qlrrstringT13_sUcP8sqlrg_pd + 0x3F54
    0x090000005B02C2B4 sqlrreorg_sendinfo__FP14db2UCinterfacei +
    0x2954
    0x090000005D295900 sqlrr_reorg_indexes__FP14db2UCinterfacei +
    0x1C0
    0x090000005DC74040
    sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5
    sqlca + 0xA40
    0x0900000057E3AAD0 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo +
    0x1770
    0x090000005DDE6844
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x4C4
    0x090000005DD6B260
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x280
    0x090000005DD6E2E4
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2264
    0x090000005DD3A89C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
    0x090000005DD43394
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    0x090000005DD38960
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13E0
    0x090000005DD35DB4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x334
    0x09000000570F21A0 RunEDU__8sqeAgentFv + 0xB60
    0x09000000570D4D20 EDUDriver__9sqzEDUObjFv + 0x2E0
    0x0900000056FC3C14 sqloEDUEntry + 0x374
    </StackTrace>
    

Local fix

  • Interrupt / force the current REORG INDEX .. RECLAIM EXTENTS and
    retry
    

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27901

  • 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

    2019-01-28

  • Closed date

    2020-01-20

  • Last modified date

    2020-01-20

  • 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":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
04 May 2022