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

CARDINALITY MAY BE OVERESTIMATED WHEN THERE ARE MULTIPLE IN PRED ICATES ON
THE SAME COLUMNS AS MULTIPLE EQUALITY JOIN PREDICATE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
During planning the DB2 optimizer can make adjustments to the 
estimated cardinality of the plan to account for highly 
correlated values between columns using in multiple predicate of 
the query. When there are multiple IN predicate and multiple 
join predicate on the same columns, the adjustments made can 
cause the the optimizer to overestimate the cardinality of the 
plan. This overestimation can lead to poor plan choices and high 
cost estimates. 
 
For example the following query show an example of a query that 
may be affected. 
 
SELECT * 
  FROM T1, T2 
 WHERE T2.a = T1.a 
   and T2.b = T1.b 
   and T1.a IN (1, 2, 3, 4, 5) 
   and T1.b IN (1, 2, 3, 4, 5) 
 
In this query there are two join predicates on columns A and B 
between tables T1 and T2, in addition there are IN predicates on 
both columns A and B. If the data in the table shows a high 
degree of correlation between the values in columns A and B then 
this query may be subject to the cardinality overestimation. 
 
Using db2exfmt for suspected queries you can verify if this is 
the case by looking for the predicate pattern noted above and 
also noticing that the estimated cardinality is drastically 
increasing at the actual NLJOIN, HSJOIN or MSJOIN operation 
between tables T1 and T2.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V10                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 1                       * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Problem Fixed in DB2 Version 10.1 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.06.2012
07.11.2012
07.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList