|
Problem IC89700
|
Status: Closed |
INSTANCE TRAP DUE TO SQLRINLJNMUSTIDOINNER |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem 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) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 UDB Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v10.1 Fix Pak 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 first fixed in DB2 v10.1 Fix Pak 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2013
21.10.2013
21.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
