home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC77934 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - 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:                                         * 
* seg-v in sqlra_hash_del_stmt or sqlra_cache_del_var          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP5 or subsequent fix pack.               * 
****************************************************************
Local-Fix:
increasing package cache size (pckcachesz) may decrease 
likelihood of hitting this problem.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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

Lösung
Problem fixed in DB2 Version 9.7 Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC77940 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.08.2011
27.02.2012
20.09.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9,
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList