IBM Support

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

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 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

[{"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:
13 March 2021