DB2 FOR LUW / DB2FORLUW / 950 - DB2

A trap and instance shutdown can be seen with the following 
signature in the db2diag.log 
 
 
 
2011-07-13-16.00.12.337415-240 I16730848A1839     LEVEL: Severe 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:10 
MESSAGE : Possible memory corruption detected. 
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes 
0x820F0002 
DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8 
bytes 
0x00000000000000e0 
DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 
Object not dumped: Address: 0x00000000000000C8 Size: 24 Reason: 
Possible offset from NULL pointer 
DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 
Object not dumped: Address: 0x00000000000000E0 Size: 48 Reason: 
Possible offset from NULL pointer 
CALLSTCK: 
  [0] 0x0900000010D1F8D4 pdLog + 0x88 
  [1] 0x0900000011245E90 
@78@sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0xF0 
  [2] 0x0900000011245CD0 
sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb@glue6CF + 0x78 
  [3] 0x0900000010C283A0 sqlofmblkEx + 0x4D4 
  [4] 0x0900000010F8C944 
sqlra_hash_del_stmt__FP13SQLO_MEM_POOLP17sqlra_anchor_stmtP17sql 
ra_cached_stmtPi 
+ 0x74 
  [5] 0x0900000010F8C7D0 
sqlra_cache_del_empty_stmt__FP8sqlrr_cbP17sqlra_anchor_stmtP17sq 
lra_cached_stmtPi 
+ 0x28 
  [6] 0x09000000109C7348 
sqlra_cache_del_empty_stmt__FP8sqlrr_cbP17sqlra_anchor_stmtP17sq 
lra_cached_stmtPi@glue111B 
+ 0x70 
  [7] 0x0900000011D3E478 
sqlra_cache_del_var__FP8sqlrr_cbP16sqlra_cached_variP23sqlra_cac 
hed_dependency 
+ 0x208 
  [8] 0x09000000137FD804 
sqlra_csm_drop_var__FP8sqlrr_cbPP16sqlra_cached_variP23sqlra_cac 
hed_dependencyPi 
+ 0x428 
  [9] 0x0900000013803D44 
sqlra_csm_flush_vars_anchor__FP8sqlrr_cbP17sqlra_anchor_stmt + 
0x25C 
 
other segmentation faults in sqlra_ code may also result, 
including ones with 
 
sqlra_cache_del_var 
 
in the stack

**************************************************************** 
* USERS AFFECTED:                                              * 
* All server types                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Move to DB2 for LUW Version 9.5 fixpack 9                    * 
****************************************************************

increasing package cache size (pckcachesz) may decrease 
likelihood of hitting this problem.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in DB2 for LUW Version 9.5 fixpack 9

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.08.2011
28.03.2012
28.03.2012

9.5.FP9