DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 Instance may crash while compiling SQL statement if it runs 
out of the statement heap memory. 
 
Here are the example error messages in the db2diag.log and the 
call stacks you might have seen. 
 
1) The db2diag messages shows it ran out of the statement heap 
memory. 
 
2012-00-00-00.10.59.559211+540 E83622581A715      LEVEL: Warning 
PID     : 201118               TID  : 73815       PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE 
APPHDL  : 0-10974              APPID: AA1AAA7A.D20E.178815001107 
AUTHID  : DB200 
EDUID   : 73815                EDUNAME: db2agent (SAMPLE) 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           : 4096 bytes. 
Physical heap size             : 393216 bytes. 
Configured heap size           : 41943040 bytes. 
Unreserved memory used by heap : 0 bytes. 
Unreserved memory left in set  : 0 bytes. 
 
2) The call stacks may show below with remove_orphaned_boxes 
function in the stacks. 
 
sqloCrashOnCriticalMemoryValidationFailure 
sqloCrashOnCriticalMemoryValidationFailure@glue6DB 
sqlofmblkEx 
sqlofmblkEx@glue7C4 
drop__9sqlnq_ftbFP13sqlnq_memPool 
box_drop_ts__9sqlnq_qtbFiN21 
box_drop__9sqlnq_qtbFiT1 
box_drop__9sqlnq_qtbFiT1@glueF5B 
remove_orphaned_boxes__9sqlnq_qurFi 
sqlnr_form_common_subexprs__FP9sqlnq_quriRi 
sqlnr_optprep__FP9sqlnq_qur 
sqlnr_optprep_action__FP10sqlnr_qrwaPiP14sqlnr_progress 
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres 
s@AF289_111 
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass 
sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress 
sqlnr_exe__FP9sqlnq_qur 
sqlnr_exe__FP9sqlnq_qur@glue155E 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_enviT7PP9sqlnq_qur 
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq 
lrr_cmpl_env 
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ 
LOCK_INFOP16sqlra_cached_varPiPUl 
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi 
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb 
sqlra_get_var__FP8sqlrr_cbiT2bPbT5 
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo 
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface 
.sqljsParse.fdpr.clone.280__FP13sqljsDrdaAsCbP14db2UCinterfaceP8 
sqeAgentb 
@64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle 
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb 
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T 
RunEDU__8sqeAgentFv 
EDUDriver__9sqzEDUObjFv 
sqloEDUEntry

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 6 or later.               * 
****************************************************************

Increase APPL_MEMORY and STMTHEAP to avoid out of statement heap 
memory.

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
 

First fixed in Version 9.7 Fix Pack 6.

keiner bekannt / siehe Local-Fix

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

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

14.02.2012
14.06.2012
14.06.2012

9.7.FP6