DB2 FOR LUW / DB2FORLUW / A10 - DB2

Runs a DRDA statement which contains parameter marker in 
passthru session will cause DB2 crash, the following log can be 
seen in db2diag.log: 
 
2012-05-21-12.00.15.781587+060 I1304802E476        LEVEL: Error 
PID     : 677                  TID  : 140506659022592PROC : 
db2sysc 0 
INSTANCE: db2ods               NODE : 000          DB   : ODS 
APPHDL  : 0-9026               APPID: *LOCAL.db2ods.120521110027 
AUTHID  : DB2ODS 
EDUID   : 62637                EDUNAME: db2agent (ODS) 0 
FUNCTION: DB2 UDB, drda wrapper, 
DRDA_Statement::process_input_data, probe:5 
MESSAGE : No parameter markers allowed in passthru statements 
 
The trap file will contain this information: 
 
</Siginfo_t> 
Signal #11 (SIGSEGV): si_addr is 0x0000000000000010, si_code is 
0x00000001 (SEGV_MAPERR:Address not mapped to object.) 
</SignalDetails> 
 
<POFDisassembly> 
 _ZN14DRDA_Statement18process_input_dataEv + 0x0127 
 (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 
 
 0x00007FCC309503F3 : 48035110E8CCE6FC 
</POFDisassembly> 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00007FCCCEBD8293 ossDumpStackTraceEx + 0x01ef 
  (/home/db2ods/sqllib/lib64/libdb2osse.so.1) 
0x00007FCCCEBD3052 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
  (/home/db2ods/sqllib/lib64/libdb2osse.so.1) 
0x00007FCCD18A5943 sqlo_trce + 0x03fb 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD18EB801 sqloEDUCodeTrapHandler + 0x026b 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD46E05D0 address: 0x00007FCCD46E05D0 ; dladdress: 
0x00007FCCD46D1000 ; offset in lib: 0x000000000000F5D0 ; 
  (/lib64/libpthread.so.0) 
0x00007FCC309503F3 _ZN14DRDA_Statement18process_input_dataEv + 
0x0127 
  (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 
0x00007FCC30951801 _ZN14DRDA_Statement4openEv + 0x0055 
  (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 
0x00007FCC30955301 _ZN13DRDA_Passthru4openEv + 0x0075 
  (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 
0x00007FCC30BED5B0 _Z22sqlqg_FMP_PassthruOpenP15sqlri_rpassthru 
+ 0x004c 
  (/home/db2ods/sqllib/lib64/libdb2qgstp.so) 
0x00007FCC30BE3411 
_Z11sqlqgRouterP17sqlqg_FMP_RequestPP15sqlqg_FMP_ReplyP10sqlri_u 
fob + 0x2631 
  (/home/db2ods/sqllib/lib64/libdb2qgstp.so) 
0x00007FCC30BE64A4 sqlqg_fedstp_hook + 0x007a 
  (/home/db2ods/sqllib/lib64/libdb2qgstp.so) 
0x00007FCCD19B6055 _Z11sqlqgDyloadP10sqlri_ufob + 0x0129 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD1D41F8D 
_Z22sqlriFedInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf 
+ 0x008b 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD1D4216D 
_Z21sqlriFedInvokeInvokerP10sqlri_ufobP14sqlqg_Fmp_Info + 0x00d9 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD1A028FD 
_Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply 
+ 0x01d3 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD19F0768 _Z17sqlqgPassthruOpenP15sqlri_rpassthru + 
0x019c 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD1BE1750 
_Z19sqlri_passthru_openP8sqlrr_cbP15sqlri_rpassthru + 0x013c 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD1BE1AC8 _Z21sqlri_passthru_routerP8sqlrr_cb + 0x018e 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD266E6ED _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm 
+ 0x00fb 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD03C1824 
_Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x0c08 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFFD8B58 
_Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x03fa 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD2602789 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface + 0x00b9 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFFCA323 
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 
0x035b 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFFBF038 address: 0x00007FCCCFFBF038 ; dladdress: 
0x00007FCCCF070000 ; offset in lib: 0x0000000000F4F038 ; 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFFC6403 address: 0x00007FCCCFFC6403 ; dladdress: 
0x00007FCCCF070000 ; offset in lib: 0x0000000000F56403 ; 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFFC3D0A address: 0x00007FCCCFFC3D0A ; dladdress: 
0x00007FCCCF070000 ; offset in lib: 0x0000000000F53D0A ; 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFFC3A78 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 
0x0102 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCCFEF7B72 _ZN8sqeAgent6RunEDUEv + 0x0a72 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD05D3C9C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD05D3BF3 _Z10sqlzRunEDUPcj + 0x0009 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD03435AA sqloEDUEntry + 0x02f4 
  (/home/db2ods/sqllib/lib64/libdb2e.so.1) 
0x00007FCCD46D85F0 address: 0x00007FCCD46D85F0 ; dladdress: 
0x00007FCCD46D1000 ; offset in lib: 0x00000000000075F0 ; 
  (/lib64/libpthread.so.0) 
0x00007FCCCDFDA84D clone + 0x006d 
  (/lib64/libc.so.6) 
</StackTrace>

User affected: 
  Users of  in InfoSphere Federation Server 
Problem description and summay: 
  See error description

Don't run a statement containing parameter marker in passthru 
session

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was fistly fixed in Version 10, FixPak 2. This 
fix should be applied on the federation Server.

keiner bekannt / siehe Local-Fix

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

04.11.2012
04.01.2013
04.01.2013