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

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

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

Local fix

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

Problem summary

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

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

  JR42988

• 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

• RA10 PSY

     UP