DB2 FOR LUW / DB2FORLUW / A10 - DB2

When extended indicator and REOPT ALWAYS are enabled,  db2 
instance may trap in stacks  as below: 
 
StackTrace1: 
 
0x00002ABAD80BE625 
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 
0x0385 
        (/home/db2sdin1/sqllib/lib64/libdb2osse.so.1) 
0x00002ABAD80BE22C ossDumpStackTraceV98 + 0x002c 
        (/home/db2sdin1/sqllib/lib64/libdb2osse.so.1) 
0x00002ABAD80B932D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00fd 
        (/home/db2sdin1/sqllib/lib64/libdb2osse.so.1) 
0x00002ABAD270C5CF sqlo_trce + 0x03ef 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD2761BFF sqloEDUCodeTrapHandler + 0x025f 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACB5777C0 address: 0x00002ABACB5777C0 ; dladdress: 
0x00002ABACB568000 ; offset in lib: 0x000000000000F7C0 ; 
        (/lib64/libpthread.so.0) 
0x00002ABAD05E32CE 
_Z14sqlra_load_varP8sqlrr_cbP16sqlra_cached_var + 0x024e 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD062C075 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0be5 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD37473D3 _Z29sqlrr_process_execute_requestP8sqlrr_cbib 
+ 0x0293 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD3745C7B _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo 
+ 0x026b 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD3695E26 
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 
0x04c6 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD369362E 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface + 0x007e 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD3693D77 
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 
0x0377 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACF83D8E4 address: 0x00002ABACF83D8E4 ; dladdress: 
0x00002ABACB788000 ; offset in lib: 0x00000000040B58E4 ; 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACF83BEC9 address: 0x00002ABACF83BEC9 ; dladdress: 
0x00002ABACB788000 ; offset in lib: 0x00000000040B3EC9 ; 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACF838F69 address: 0x00002ABACF838F69 ; dladdress: 
0x00002ABACB788000 ; offset in lib: 0x00000000040B0F69 ; 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACF838B5B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 
0x00eb 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACF55EE91 _ZN8sqeAgent6RunEDUEv + 0x08b1 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD0B00CA4 _ZN9sqzEDUObj9EDUDriverEv + 0x00f4 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABAD0354617 sqloEDUEntry + 0x02f7 
        (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002ABACB56F7B6 address: 0x00002ABACB56F7B6 ; dladdress: 
0x00002ABACB568000 ; offset in lib: 0x00000000000077B6 ; 
        (/lib64/libpthread.so.0) 
0x00002ABAD8E579CD clone + 0x006d 
        (/lib64/libc.so.6) 
 
 
StackTrace2: 
 
0x00002B3C61456625 
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 
0x0385 
  (/home/db2sdin1/sqllib/lib64/libdb2osse.so.1) 
0x00002B3C6145622C ossDumpStackTraceV98 + 0x002c 
  (/home/db2sdin1/sqllib/lib64/libdb2osse.so.1) 
0x00002B3C6145132D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00fd 
  (/home/db2sdin1/sqllib/lib64/libdb2osse.so.1) 
0x00002B3C5BAA45CF sqlo_trce + 0x03ef 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5BAF9BFF sqloEDUCodeTrapHandler + 0x025f 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5490F7C0 address: 0x00002B3C5490F7C0 ; dladdress: 
0x00002B3C54900000 ; offset in lib: 0x000000000000F7C0 ; 
  (/lib64/libpthread.so.0) 
0x00002B3C5BED479F 
_ZN32sqlraExtendedIndicatorDescriptor13selectiveCopyEPS_P8sqlrr_ 
cb + 0x002f 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5997B34A 
_Z14sqlra_load_varP8sqlrr_cbP16sqlra_cached_var + 0x02ca 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C599C4075 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0be5 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5CADF3D3 _Z29sqlrr_process_execute_requestP8sqlrr_cbib 
+ 0x0293 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5CADDC7B _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo 
+ 0x026b 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5CA2DE26 
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 
0x04c6 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5CA2B62E 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface + 0x007e 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C5CA2BD77 
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 
0x0377 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C58BD58E4 address: 0x00002B3C58BD58E4 ; dladdress: 
0x00002B3C54B20000 ; offset in lib: 0x00000000040B58E4 ; 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C58BD3EC9 address: 0x00002B3C58BD3EC9 ; dladdress: 
0x00002B3C54B20000 ; offset in lib: 0x00000000040B3EC9 ; 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C58BD0F69 address: 0x00002B3C58BD0F69 ; dladdress: 
0x00002B3C54B20000 ; offset in lib: 0x00000000040B0F69 ; 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C58BD0B5B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 
0x00eb 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C588F6E91 _ZN8sqeAgent6RunEDUEv + 0x08b1 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C59E98CA4 _ZN9sqzEDUObj9EDUDriverEv + 0x00f4 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C596EC617 sqloEDUEntry + 0x02f7 
  (/home/db2sdin1/sqllib/lib64/libdb2e.so.1) 
0x00002B3C549077B6 address: 0x00002B3C549077B6 ; dladdress: 
0x00002B3C54900000 ; offset in lib: 0x00000000000077B6 ; 
  (/lib64/libpthread.so.0) 
0x00002B3C621EF9CD clone + 0x006d 
  (/lib64/libc.so.6) 
 
In order to hit the trap, both extended indicator and REOPT 
ALWAYS need to be enabled.

**************************************************************** 
* USERS AFFECTED:                                              * 
* When extended indicator and REOPT ALWAYS are enabled.        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 FP5 or later version.                   * 
****************************************************************

1) disable extended Indicator, an example in JCC application: 
 
  String url = "jdbc:default:connection"; 
  Properties prop = new Properties(); 
  prop.put("enableExtendedIndicators", "2"); 
 
  try { 
      con = DriverManager.getConnection(url, prop); 
  ... 
 
or 
 
2) disable REOPT ALWAYS, use either NONE or ONCE instead.

This problem is firstly fixed on V10.1 FP5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.07.2014
14.07.2015
14.07.2015