IBM Support

IT30945: DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES

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

  • Db2 may terminate abnormally while using the following explain
    modes:
      -RECOMMEND INDEXES
      -EVALUATE INDEXES
      -RECOMMEND PARTITIONINGS
      -EVALUATE PARTITIONINGS
    
    An example stack trace seen in this scenario looks similar to
    the following:
    ------FUNCTION------
    _Z19sqldLockTableFixTCBP8sqeAgenttthmiiimmiPciS1_iP14SQLP_LOCK_I
    NFOPP8SQLD_TCBjj
    _Z12sqldScanOpenP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv
    _Z24sqlno_advise_get_indexesP16sqlnx_exp_fidtidjPiPPv
    _Z29sqlno_advise_fill_index_cacheP13sqlno_globals
    _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
    lrr_cmpl_enviiPP9sqlnq_qur
    _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
    lrr_cmpl_env
    _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP
    _LOCK_INFOP16sqlra_cached_varPiS5_Pb
    _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj
    jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK
    _INFOPP16sqlra_cached_varS8_bSA_Pb
    _Z13sqlra_get_varP8sqlrr_cbiibPbS1_
    _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo
    _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb
    _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T
    _ZN8sqeAgent6RunEDUEv
    _ZN9sqzEDUObj9EDUDriverEv
    sqloEDUEntry
    clone
    

Local fix

  • The problem can be avoided by querying the ADVISE_INDEX explain
    table before enabling the following explain modes:
      -RECOMMEND INDEXES
      -EVALUATE INDEXES
    
    And by querying the ADVISE_PARTITIONINGS explain table before
    enabling the following explain modes:
      -RECOMMEND PARTITIONINGS
      -EVALUATE PARTITIONINGS
    
    Note: Querying the explain tables above only needs to be done
    once while the database manager is up.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30945

  • 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-11-14

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

    IT30943

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]

Document Information

Modified date:
01 April 2021