IC87028: INSTANCE TRAP DUE TO SQLRINLJNMUSTIDOINNER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Instance trap when run a SQL that hits out of memory error.
    
    SQL0956C  Not enough storage is available in the database heap
    to process the
    statement
    
    In db2diag.log:
    
    FUNCTION: DB2 UDB, base sys utilities, sqleIntrptWaitPostInit,
    probe:5
    RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH
              "No memory available in 'Database Heap'"
              DIA8302C No memory available in the database heap.
    
    
    
    Sample call stack:
    
    Signal #11 (SIGSEGV): si_addr is 0x0000000000000004, si_code is
    0x00000001 (SEGV_MAPERR:Address not mapped to object.)
    ..
    NIP:    0000040003C9D1C0
    
     0000040003c9d1c0 sqloPostEDUWaitPost + 0xfffffffffb5d7120
      ( = offset 0x3C6D1C0 in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    
    
    <StackTrace>
    -----Frame------ ------Address----- ------Function +
    Offset------
    0x0000040599BEC6A0 ** Symbol lookup for address 0000000000000008
    failed **.
    0x0000040599BECAF0 00000400045c8844
    _Z21sqlriNljnMustIDoInnerP8sqlrr_cbP15sqlriSharedNljnjPb +
    0xfffffffffbed4c4c
      ( = offset 0x4598844 in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    0x0000040599BECC70 00000400045c7e7c
    _Z17sqlriNljnNonPipedP8sqlrr_cb + 0xfffffffffbed429c
      ( = offset 0x4597E7C in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    0x0000040599BECF60 0000040004649e8c _Z9sqlrihsjnP8sqlrr_cb +
    0xfffffffffbf53bf4
      ( = offset 0x4619E8C in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    0x0000040599BED580 00000400045447ec
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm +
    0xfffffffffbe53ffc
      ( = offset 0x45147EC in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    0x0000040599BED680 00000400040f6304
    _Z16sqlrr_smp_routerP8sqlrr_cb + 0xfffffffffba13a64
      ( = offset 0x40C6304 in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    0x0000040599BED780 00000400040f3920
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T +
    0xfffffffffba110c8
      ( = offset 0x40C3920 in
    /sn1/dbhome/bgqsysdb/sqllib/lib64/libdb2e.so.1)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fixpack 8                         *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in Version 9.7 Fixpack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87028

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-05

  • Closed date

    2013-04-08

  • Last modified date

    2013-04-08

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

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

    IC89700

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

  • 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:

9.7

Reference #:

IC87028

Modified date:

2013-04-08

Translate my page

Machine Translation

Content navigation