IBM Support

IT22447: VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TO ACCESS OF THE TABLE PACKED DESCRIPTOR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If auto-runstats is running on a table, then the rollback of the
    runstats or other DDL on the table that occurs while other
    transactions are in the middle of compilation can result in
    various -901 SQLCODEs or traps as the table packed descriptor
    may be removed from memory while being accessed.
    
    Example symptoms include
    
    Traps with the following stacks:
    
    sqlcode -901:
    
    "Invalid collation ID" from sqlnq_get_collation
    "qunp has more columns then base table" from
    sqlng_build_colRefs_obj
    
    
    Traps:
    
    Sig#11 Trap sqlng_build_IndexList_obj
    
    0x00007FCFE0C33B8C sqloEDUCodeTrapHandler + 0x03ac
    0x00007FCFDF982D15
    _Z25sqlng_build_IndexList_objP9sqlng_blkttP8sqlrg_pdP18sqlrg_dat
    apartinfoPP14sqlriIndexList + 0x02e5
    0x00007FCFDF93F041
    _Z20sqlngRecordTableInfoP9sqlng_blktthP9sqlnq_ftbbbP19sqlno_plan
    _operator + 0x0321
    0x00007FCFDFA5455A
    _Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb
    + 0x06fa
    0x00007FCFDF94A75E
    _Z26sqlngProcessCdeCseProducerP9sqlng_blkP19sqlno_plan_operator
    + 0x061e
    0x00007FCFDFA541AF
    _Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb
    + 0x034f
    
    Sig#11 Trap sqlngMemBlockLookup
    
    0x00007F950C8D7B8C sqloEDUCodeTrapHandler + 0x03ac
    0x00007F950B70F2D9
    _Z19sqlngMemBlockLookupP9sqlng_blkPvmRP15sqlngSectObject +
    0x03a9
    0x00007F950B70DC70 _Z23sqlngSectSetPtrInternalP9sqlng_blkPvS1_m
    + 0x0130
    0x00007F950B6E31F9
    _Z18sqlng_build_TQA_opP9sqlng_blkP19sqlno_plan_operator + 0x0869
    0x00007F950B6E1F89
    _Z19sqlng_process_tq_opP9sqlng_blkP19sqlno_plan_operator +
    0x0739
    0x00007F950B6F82E4
    _Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb
    + 0x0484
    
    Sig #11 Trap sqlrlc_find_invalidate
    
    0x00007F421E485B8C sqloEDUCodeTrapHandler + 0x03ac
    0x00007F421F5BE64E
    _Z22sqlrlc_find_invalidateP8sqlrr_cbP10sqlrlc_keyjP8SQLZ_RID +
    0x07ce
    0x00007F421F5FBFE6
    _Z14sqlrlc_end_uowP8sqlrr_cbiP19sqlr_savepoint_info + 0x0246
    0x00007F421EAAE020
    _Z29sqlrr_cleanup_tran_before_DPSP8sqlrr_cbiiiiiiiPiS1_ + 0x1520
    0x00007F421EADDABA _Z17sqlrr_tran_routerP8sqlrr_cb + 0x0eea
    

Local fix

  • disable autorunstats (database configuration auto_runstats)
    

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22447

  • 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-09-19

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

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

    IT22435

  • 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:
19 March 2018