IBM Support

IT29658: DB2 MIGHT ABEND with -901 OR CAN HAVE WRONG RESULT WHEN RUNNING QUERIES WITH OUTER JOINS AND INNER JOINS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 might abend when running a query with the following
    characteristics:
    1. the query has at least one outer join(OJ)
    2. on the row preserving(RP) side of this OJ, there are multiple
    table inner join(IJ)
    3. a local predicates applied on at least 2 inner joined tables
    on the RP side of the OJ reference the same constants; one of
    these local predicates references a column output to the OJ and
    this column is also used in an OJ predicate
    
    The crash stack:
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007FF194AF1B06
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x04ea
                    (/home/wanguod/sqllib/lib64/libdb2osse.so.1)
    0x00007FF194AF2375 ossDumpStackTraceV98 + 0x007f
                    (/home/wanguod/sqllib/lib64/libdb2osse.so.1)
    0x00007FF194AEC776 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x04e0
                    (/home/wanguod/sqllib/lib64/libdb2osse.so.1)
    0x00007FF1B95BCB4A sqlo_trce + 0x06bb
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B9890807 sqloDumpDiagInfoHandler + 0x02ac
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1C7768850 address: 0x00007FF1C7768850 ; dladdress:
    0x00007FF1C7759000 ; offset in lib: 0x000000000000F850 ;
                    (/lib64/libpthread.so.0)
    0x00007FF1C77659C6 pthread_kill + 0x0036
                    (/lib64/libpthread.so.0)
    0x00007FF1B5EC00BB _Z14ossPthreadKillmj + 0x0053
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B98918E2 sqloDumpEDU + 0x0072
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1991B4DB9 _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
    0x01f8
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1BA553ED2 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x1398
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1BCCED9B3 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x004e
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1BCCEB0C7
    _Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x059f
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B774BF4E _Z10sqlnn_erdsiiiiiz + 0x0311
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B74AA1F8
    _Z16sqlno_add_to_setP13sqlno_globalsP9sqlno_sdbP10sqlno_apcbiP9s
    qlno_set + 0x0170
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DEF141
    _Z17sqlno_analyze_qncP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP9sql
    nq_pidP9sqlno_prdP9sqlnq_qun13SQLNN_BOOLEANSB_P12SQLNO_COLTYP +
    0x0a6e
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DEBD61
    _Z19sqlno_analyze_relopP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP9s
    qlnq_pidP9sqlno_prd + 0x09ef
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DF1246
    _Z23sqlno_analyze_pred_exprP13sqlno_globalsP9sqlno_sfbP9sqlno_qt
    bP9sqlnq_pidPi + 0x0661
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DE8CB2
    _Z19sqlno_assign_optprdP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9s
    qlnq_prdPi + 0x0583
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DDF4EA
    _Z16sqlno_assign_prdP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqln
    q_prd + 0x0117
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7CBD3F4
    _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ
    LNN_BOOLEAN + 0x03e4
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7E3D29B
    _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_
    opr + 0x05ec
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7CBD3F4
    _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ
    LNN_BOOLEAN + 0x03e4
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DF22C5
    _Z29sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sq
    lnq_oprP9sqlnq_qun + 0x03d1
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7CBD3F4
    _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ
    LNN_BOOLEAN + 0x03e4
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7E3DABF
    _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_
    opr + 0x0e10
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7CBD3F4
    _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ
    LNN_BOOLEAN + 0x03e4
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7DF22C5
    _Z29sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sq
    lnq_oprP9sqlnq_qun + 0x03d1
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    0x00007FF1B7CBD3F4
    _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ
    LNN_BOOLEAN + 0x03e4
                    (/home/wanguod/sqllib/lib64/libdb2e.so.1)
    

Local fix

  • db2set -im DB2COMPOPT=NOOJSJ
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp6 or later                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to db2_v111m4fp6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29658

  • 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-07-08

  • Closed date

    2021-03-12

  • Last modified date

    2021-03-12

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

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

    IT31800

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