DB2 FOR LUW / DB2FORLUW / 970 - DB2

The DB2 server may terminate abnormally while compiling a SQL 
statement.  This can happen when a dependent view requires 
revalidation, and the revalidation fails due to an out-of-memory 
condition.  The stack looks something like the following example 
from Linux: 
 
_ZNK20sqlnq_multipart_name22SQL_identifier_compareERKS_ + 0x002c 
 
_Z16sqlnn_regen_viewPhsS_sS_sS_sbP17sqlrl_table_parmsPbS2_S2_b + 
0x091b 
_Z16sqlrl_regen_viewP8sqlrr_cbPhsS1_sS1_sS1_ssbP17sqlrl_table_pa 
rmsPbS4_b + 0x05bd 
 
_Z25sqlrlRevalidateDepObjectsP8sqlrr_cbP16sqlrlCatalogScanPhP10s 
qlrl_sstrS5_PiS6_b + 0x06f6 
 
 
In addition, there will be an out-of-memory condition in the 
db2diag.log: 
 
2011-11-15-16.39.34.578623-300 E1670407E727        LEVEL: 
Warning 
PID     : 4291                 TID  : 47327972682048PROC : 
db2sysc 0 
INSTANCE: instname             NODE : 000          DB   : DBNAME 
APPHDL  : 0-963                APPID: 
*LOCAL.nyqit009.111115214055 
AUTHID  : AUTHID 
EDUID   : 61                   EDUNAME: db2agent (DBNAME) 0 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloMemLogPoolConditions, probe:30 
DATA #1 : <preformatted> 
Out of memory failure for Statement Heap on node 0. 
Requested block size           : 2888 bytes. 
Physical heap size             : 33554432 bytes. 
Configured heap size           : 33554432 bytes. 
Unreserved memory used by heap : 0 bytes. 
Unreserved memory left in set  : 0 bytes.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 6                            * 
****************************************************************

Increase statement heap to avoid the out-of-memory condition, or 
revalidate views using ADMIN_REVALIDATE_DB_OBJECTS procedure.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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 was first fixed in Version 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

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

06.12.2011
17.12.2012
17.12.2012

9.7.FP6