IBM Support

JR27860: INTERMITTENT TRAP ON THE GATEWAY IN SQLJRPREPROCESSSETI

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Intermittent trap on gateway on DB2 V8 FP 14 on Linux OS
    connecting to Z/OS. This is the stack trace -
    
    
    
    
    
    
    
    ---FUNC-ADDR---- ------FUNCTION + OFFSET------
    0000002A97CFA748 ossDumpStackTrace + 0x0088
      (/db2home/inst1/sqllib/lib/libdb2osse.so.1)
    0000002A97CEDA06 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00f6
      (/db2home/inst1/sqllib/lib/libdb2osse.so.1)
    0000002A97163B70 sqlo_trce + 0x03e0
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95FEEBCE sqloEDUCodeTrapHandler + 0x005e
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95679260 address: 0x0000002A95679260 ; dladdress:
    0x0000002A9566D000 ; offset in lib: 0x000000000000C260 ;
      (/lib64/tls/libpthread.so.0)
    0000002A97244831 _Z16sqljrProcessSetiP7UCintfc13SQLJRSETITYPE +
    0x0c31
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A97243A2F _Z19sqljrPreProcessSetiP7UCintfc + 0x024f
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A9722694A _Z18sqljrPreProcessingP7UCintfc13sqljrRqstTypeb
    + 0x039a
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A97213823 _Z17sqljrDrdaArCommitP7UCintfc + 0x0083
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95FA582E _Z16sqljs_ddm_rdbcmmP7UCintfcP14sqljsDDMObject
    + 0x013e
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95F9615D
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP14sqljsDDMObjectP7UCin
    tfc + 0x03ad
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95F951E9 _Z10sqljsParseP13sqljsDrdaAsCbP7UCintfc +
    0x0159
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95F90E4A address: 0x0000002A95F90E4A ; dladdress:
    0x0000002A95781000 ; offset in lib: 0x000000000080FE4A ;
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95F940B2 _Z17sqljsDrdaAsDriverP17sqlcc_init_struct +
    0x20e2
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95D7D9AF _Z12sqleRunAgentPcj + 0x014f
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95FEF004 _Z13sqloCreateEDUPFvPcjES_mP13SQLO_EDU_INFOPi +
    0x02f4
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95FF0718 sqloInitEDUServices + 0x0848
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000002A95FEB4B9 sqloRunInstance + 0x06d9
      (/db2home/inst1/sqllib/lib/libdb2e.so.1)
    0000000000408F9C DB2main + 0x06bc
      (db2agentg (DB2XQA  ))
    0000000000409639 main + 0x0009
      (db2agentg (DB2XQA  ))
    0000002A983E9ACD __libc_start_main + 0x00fd
      (/lib64/tls/libc.so.6)
    0000000000404A1A sqlt_system_error + 0x0042
      (db2agentg (DB2XQA  ))
    

Local fix

Problem summary

  • INTERMITTENT TRAP ON THE GATEWAY IN SQLJRPREPROCESSSETI
    

Problem conclusion

  • First Fixed on DB2 V9.5 Fixpak 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR27860

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-19

  • Closed date

    2009-09-23

  • Last modified date

    2009-09-23

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

    JR27195

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 September 2009