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

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows

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