|
Problem IC87028
|
Status: Closed |
INSTANCE TRAP DUE TO SQLRINLJNMUSTIDOINNER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fixpack 8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in Version 9.7 Fixpack 8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89700
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.10.2012
08.04.2013
08.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
