IBM Support

IT20126: DB2 SIG #11 CRASH IN SQLNO_HINT_VALIDATE WHEN REBINDING USING THE APREUSE (ACCESS PLAN REUSE) OPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 crashed with a signal #11 trap while recompiling a query
    with the APREUSE bind option set.
    In this case the option was set automatically by the rebind
    daemon, but this scenario is also possible when the rebind is
    initiated by a user.
    
    Stack traceback excerpt:
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00002AAAB9085686
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0356
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
    0x00002AAAB90852CB ossDumpStackTraceV98 + 0x002b
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
    0x00002AAAB9081477 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00d7
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
    0x00002AAAB18E6B37 sqlo_trce + 0x03c7
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAB1A4CE6C sqloEDUCodeTrapHandler + 0x03ac
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000003CD800F7E0 address: 0x0000003CD800F7E0 ; dladdress:
    0x0000003CD8000000 ; offset in lib: 0x000000000000F7E0 ;
                    (/lib64/libpthread.so.0)
    0x00002AAAB0D6B4AB
    _Z19sqlno_hint_validateP13sqlno_globalsP19sqlno_plan_operatorP10
    sqlno_hintP9sqlno_qtbP13SQLNN_BOOLEAN + 0x041b
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAB0B67AFE
    _Z22sqlno_crule_save_plansP13sqlno_globalsP13sqlno_context9sqlno
    _setP14sqlno_planlistP10sqlno_hint + 0x189e
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAB0B713F9
    _Z22sqlno_crule_save_plansP13sqlno_globalsP13sqlno_context9sqlno
    _setP14sqlno_planlist + 0x0009
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAB0B6AE92
    _Z18sqlno_crule_accessP13sqlno_globalsP9sqlno_qtbP18sqlno_join_c
    ontext9sqlno_setS5_S5_S5_S5_13SQLNN_BOOLEANS5_PS6_ + 0x0272
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAB0CEA487
    _Z14sqlno_plan_qunP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_
    qun + 0x1217
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAB0CF8C4F
    _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_
    opr + 0x09bf
    
    (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    ...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 11.1.1.2.2                            *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 11.1.1.2.2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20126

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

  • Closed date

    2017-06-23

  • Last modified date

    2017-06-23

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

  • 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

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

Document Information

Modified date:
29 June 2020