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 | |
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 |