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

RUNSTATS USE PROFILE RESULTS IN TRAP WHEN PROFILE IS SET WITH AL L COLUMNS
+ DISTRIBUTION ON KEY COLUMNS OPTION AND WE HAVE INDEX

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
DESCRIPTION: 
 
RUNSTATS USE PROFILE results in memory corruption and trap when 
we have an index created on expression column and the profile is 
set with ALL COLUMNS + DISTRIBUTION ON KEY COLUMNS option. 
 
 
Ex: 
 
create table s1.t1 (c1 int, c2 int, c3 varchar(20), c4 int) 
DB20000I  The SQL command completed successfully. 
 
create index s1.id1 on s1.t1 (c1,c2) 
DB20000I  The SQL command completed successfully. 
 
create index s1.id2 on s1.t1 (c4, upper(c3)) 
DB20000I  The SQL command completed successfully. 
 
runstats on table s1.t1 on all columns with distribution on key 
columns set profile only 
DB20000I  The RUNSTATS command completed successfully. 
 
runstats on table s1.t1 use profile 
SQL2310N  The utility could not generate statistics.  Error 
"-1224" was 
returned. 
 
 
 
WORKAROUND: 
 
Specify explicit column names instead of "ALL COLUMNS" option to 
avoid the issue
Problem-Zusammenfassung:
RUNSTATS USE PROFILE RESULTS IN TRAP WHEN PROFILE IS SET WITH AL 
L COLUMNS + DISTRIBUTION ON KEY COLUMNS OPTION AND WE HAVE INDEX
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2014
20.01.2016
20.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList