IBM Support

IT37147: CRASH ENCOUNTERED WHEN THERE IS A UNION/NLJN/ISCAN/SORT COMBINATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Internal codegen pushdown through Union logic does not work when
    some Union columns are coming from lolepops above the Union.
    
    This case needs to be detected and blocked.
    
    Following stack is seen :
    
    ossDumpStackTraceV98
    _ZN11OSSTrapFile4dumpEmiP9siginfo_tPv
    sqlo_trce
    sqloEDUCodeTrapHandler
    _Z22sqldFastFormatFixedVarP8sqeAgentP15SQLD_TDATAREC32PP10SQLD_V
    ALUEP8SQLD_TCBj
    _Z16sqlsFormatRecordP8sqeAgentP10SQLS_SLDESP10SQLS_SORTSPP10SQLD
    _VALUE
    _Z8sqlsinsrP8sqeAgentPcPhP12sqlri_vectorPP10SQLD_VALUE
    _Z9sqlrsinsrP8sqlrr_cbP10sqlri_iudo
    _Z8sqlrisr2P8sqlrr_cb
    _Z13sqldDataFetchP8SQLD_CCBP8SQLZ_RIDmP7SQLI_CB
    _Z8sqlischfP7SQLI_CBtj
    _Z7sqlirdkP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBmP8SQLD_KEYP12SQLI_K
    EYDATAP9sqli_scanPi
    _Z14sqldIndexFetchP8SQLD_CCBP8SQLZ_RID
    _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP
    12SQLD_ID_LISTP9SQLP_LSN8
    _Z17sqlritaSimplePermP8sqlrr_cb
    _Z8sqlriunnP8sqlrr_cbP10sqlri_stob
    _Z8sqlrisetP8sqlrr_cb
    _Z14sqlriNljnPipedP8sqlrr_cb
    _Z14sqlriNljnPipedP8sqlrr_cb
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
    _Z16sqlrr_smp_routerP8sqlrr_cb
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T
    _Z21sqleProcessSubRequestP8sqeAgent
    

Local fix

  • db2set DB2_TCG_DEFAULT_OPTIONS=?set disable_pushdown on?
    or
    db2set DB2_TCG_DEFAULT_OPTIONS=?set multi_stream_pushdown off?
    
    Restart the instance after you have setup the above registry
    variable, and REBIND the packages.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * UNION WITH CORRELATED COLUMNS                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description. Please, install this fix.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37147

  • 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

    2021-06-07

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT37704

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB50 PSY

       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:
03 May 2022