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

THE QUERY COMPILER CAN ASSUME A DEFAULT CARDINALITY FOR A CGTT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In environments where real-time statistics is not enabled, if 
you 
do not perform runstats on a CGTT, the query compiler will use a 
default cardinality estimate of 1000.  This behaviour differs 
from DGTTs, where the query compiler will try to estimate the 
table cardinality based on the object's physical size.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix pack 10.                      * 
****************************************************************
Local-Fix:
After modifications are performed on the CGTT, for example, 
after it is populated with data, perform RUNSTATS on the CGTT
Lösung
First fixed in Version 9.7 Fix pack 10.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.07.2014
10.11.2014
10.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList