DB2 FOR LUW / DB2FORLUW / A10 - 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 UDB Users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.1 Fix Pak 3                               * 
****************************************************************

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
 

Problem first fixed in DB2 v10.1 Fix Pak 3

keiner bekannt / siehe Local-Fix

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

22.01.2013
21.10.2013
21.10.2013