IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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":"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:
20 January 2020