home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC87887 Status: Closed

DRDA STATEMENT CONTAINING PARAMETER MARKER RUNS IN PASSTHRU SESSION WILL
CAUSE DB2 CRASH

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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>
Problem Summary:
User affected: 
  Users of  in InfoSphere Federation Server 
Problem description and summay: 
  See error description
Local Fix:
Don't run a statement containing parameter marker in passthru 
session
available fix packs:
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

Solution
Problem was fistly fixed in Version 10, FixPak 2. This 
fix should be applied on the federation Server.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.11.2012
04.01.2013
04.01.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.2 FixList
10.5.0.2 FixList