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

Subscribe

You can track all active APARs for this component.

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 number

    IC87887

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-04

  • Closed date

    2013-01-04

  • Last modified date

    2013-01-04

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC87887

Modified date:

2013-01-04

Translate my page

Machine Translation

Content navigation