Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC77940 Status: Geschlossen

SEG-V IN SQLRA_HASH_DEL_STMT OR SQLRA_CACHE_DEL_VAR FUNCTIONS DURING
PACKAGE CACHE EVICTION

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All server types                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Move to DB2 for LUW Version 9.5 fixpack 9                    * 
****************************************************************
Local-Fix:
increasing package cache size (pckcachesz) may decrease 
likelihood of hitting this problem.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 for LUW Version 9.5 fixpack 9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.08.2011
28.03.2012
28.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList