DB2 - Problembeschreibung
Problem IC63920 | Status: Geschlossen |
RUNSTATS CRASHES WHEN COLLECTING STATISTICS ON A STAT VIEW HAVING A COLUMN WITH A NAME OF 128 CHARACTERS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The error occurs when the view has a column with a name of the maximum length - 128 characters. The stack is something like: 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 0x00002aaac9be9400 DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 0x00002AAAC9BE93E8 : 5858 5858 5858 5858 5858 5858 5858 5858 XXXXXXXXXXXXXXXX 0x00002AAAC9BE93F8 : 5858 5858 5858 5858 XXXXXXXX DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 0x00002AAAC9BE9400 : 5858 5858 5858 5858 5858 5858 5858 5858 XXXXXXXXXXXXXXXX 0x00002AAAC9BE9410 : 5858 5858 5858 5858 5858 5858 5858 5858 XXXXXXXXXXXXXXXX 0x00002AAAC9BE9420 : 5858 5858 5858 5858 5858 5858 5858 5858 XXXXXXXXXXXXXXXX CALLSTCK: [0] 0x00002AAAAB9862C2 pdLog + 0x398 [1] 0x00002AAAAD2DCDBC /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x25FEDBC [2] 0x00002AAAADF84D40 sqlofmblkEx + 0x84A [3] 0x00002AAAAB96050C _Z9sqlofmblkPv + 0x6 [4] 0x00002AAAAD44D89B _Z17sqlrStatViewStatsP8sqlrr_cbP10SQLD_TSTATP8sqlrg_pdPhiS5_i + 0x5C1 [5] 0x00002AAAAD47614B _Z17sqlrLocalRunstatsP8sqlrr_cbP11sqlrrstringS2_S2_httPP8sqlrg_p diiiiP16sqlrl_stats_colsPPsjPPtjdjtPP20sqlr_runstats_resultS8_m + 0x1DE5 [6] 0x00002AAAAD47C429 _Z8sqlrrstaP8sqlrr_cbP11sqlrrstringS2_S2_hhP17sqlrl_stats_parmsP KhPs + 0x1159 [7] 0x00002AAAAD4A1850 _Z17sqlrr_runstats_DAP5sqldaP5sqlca + 0x83E [8] 0x00002AAAABAF4FA9 _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent P5sqlca + 0x6B9 [9] 0x00002AAAABAF6A29 _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x3E1 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * The error occurs when the view has a column with a name of * * the maximum length - 128 characters. * **************************************************************** * RECOMMENDATION: * * Do not use column names of 128 characters in views. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 1. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.10.2009 26.01.2010 25.01.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |