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 IC77070 Status: Geschlossen

ASSIGNING STRING DATA TYPES TO LARGE OBJECT DATA TYPES IN AN INLINED SQL
FUNCTION MAY ABEND DB2 INSTANCE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Assignment operations from values of string data types to 
variables of large object data types in an inlined SQL function 
may abend DB2 instance. 
The problem may produce the following (call stack / error 
message) in db2diag.log 
 
2011-05-17-10.13.30.231132+570 E9427244E1456       LEVEL: Severe 
PID     : 5681                 TID  : 47343927814464PROC : 
db2sysc 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-32                 APPID: 
172.30.0.211.64932.110517004257 
AUTHID  : DB2INST 
EDUID   : 67                   EDUNAME: db2agent (SAMPLE) 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:999 
MESSAGE : Memory validation failure, diagnostic file dumped. 
DATA #1 : String, 28 bytes 
Corrupt pool free tree node. 
DATA #2 : File name, 39 bytes 
5681.47343927814464.mem_diagnostics.txt 
CALLSTCK: 
  [0] 0x00002B0F116F1F52 pdLog + 0x398 
  [1] 0x00002B0F131DA847 
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc + 
0x241 
  [2] 0x00002B0F13F19C0B 
_ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup + 
0x4AB 
  [3] 0x00002B0F13F18F5A sqlofmblkEx + 0x25A 
  [4] 0x00002B0F11DF0F4E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi + 
0x84 
  [5] 0x00002B0F11D5C958 
_Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace 
_siblingPm 
+ 0x17E8 
  [6] 0x00002B0F11D5AEA1 
_Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0x3B5 
  [7] 0x00002B0F11D57093 
_Z29sqlra_sqlW_get_static_sectionP8sqlrr_cbi + 0x10E9 
  [8] 0x00002B0F13F42BEF 
_Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1 
5db2UCCursorInfo 
+ 0x61F 
  [9] 0x00002B0F13F34C45 
_Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP 
15db2UCCursorInfo 
+ 0x4DB
Problem-Zusammenfassung:
Assignment operations from values of string data types to 
 
variables of large object data types in an inlined SQL function 
may abend DB2 instance. 
The problem may produce the following (call stack / error 
message) in db2diag.log 
 
2011-05-17-10.13.30.231132+570 E9427244E1456       LEVEL: Severe 
PID     : 5681                 TID  : 47343927814464PROC : 
db2sysc 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-32                 APPID: 
172.30.0.211.64932.110517004257 
AUTHID  : DB2INST 
EDUID   : 67                   EDUNAME: db2agent (SAMPLE) 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:999 
MESSAGE : Memory validation failure, diagnostic file dumped. 
DATA #1 : String, 28 bytes 
Corrupt pool free tree node. 
DATA #2 : File name, 39 bytes 
5681.47343927814464.mem_diagnostics.txt 
CALLSTCK: 
  [0] 0x00002B0F116F1F52 pdLog + 0x398 
  [1] 0x00002B0F131DA847 
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc + 
0x241 
  [2] 0x00002B0F13F19C0B 
_ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup + 
0x4AB 
  [3] 0x00002B0F13F18F5A sqlofmblkEx + 0x25A 
  [4] 0x00002B0F11DF0F4E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi + 
0x84 
  [5] 0x00002B0F11D5C958 
_Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace 
_siblingPm 
+ 0x17E8 
  [6] 0x00002B0F11D5AEA1 
_Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0x3B5 
  [7] 0x00002B0F11D57093 
_Z29sqlra_sqlW_get_static_sectionP8sqlrr_cbi + 0x10E9 
  [8] 0x00002B0F13F42BEF 
_Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1 
5db2UCCursorInfo 
+ 0x61F 
  [9] 0x00002B0F13F34C45 
_Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP 
15db2UCCursorInfo 
+ 0x4DB
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 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 was first fixed in 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: IC77493 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.06.2011
01.03.2012
01.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList