DB2 FOR LUW / DB2FORLUW / 970 - DB2

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)

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

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
 

Problem first fixed in Version 9.7 Fixpack 8

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC89700 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

05.10.2012
08.04.2013
08.04.2013

9.7.FP8