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

QUERIES NOT ROUTED TO MQTS DUE TO DEFECTIVE MQT OR STATVIEW

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
DB2 compiler attempts to match query with all of the MQT and 
statview (statistical view) that depends on query referenced 
base table or nickname.  All of the MQT and statview are 
supposed to be present in catalog table sysibm.systables. In 
case an MQT or statview is attempted to match to query but it 
has no catalog row, the query compilation used to disable MQT 
matching.   The following message is displayed in the db2exfmt 
extended diagnostic for the query: 
 
Diagnostic Details: 
     EXP0080W  The current usage of the statement or the 
     statement containing update, delete or insert or 
     constructs like sampling limits MQT matching. 
 
With this fix, the remaining MQT and statview are still matched 
to the query, and the unexpected MQT or statview is ignored by 
matching and a corresponding EXP0058W diagnostic message will 
capture its schema and name.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* General environment                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.5.fp10                                         * 
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.04.2012
27.08.2012
27.08.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP10
Problem behoben lt. FixList in der Version
9.5.0.10 FixList