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

IMPROVE THE HANDLING OF CONVERSION TO NLJOIN FROM MULTIPLE IN PREDICATES

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
If a query WHERE clause contains more than one simple IN 
predicates whose IN operand is base column and IN elements are 
composed of only literals, DB2 query compiler can convert one of 
them to NLJOIN. It is possible that the compiler converts a 
suboptimal IN predicate rather than the optimal one. The fix 
makes sure the converted IN predicate is the optimal one. 
 
Local fix: Use optimizer profile option "<INLIST2JOIN 
OPTION="ENABLE" TABLE="TABLE_NAME" COLUMN="COLUMN_NAME"/>. 
Replace TABLE_NAME and COLUMN_NAME with the real name of the IN 
predicate dedicated to DB2 compiler for attempting the IN to 
NLJOIN conversion.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* V9.5                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If a query WHERE clause contains more than one simple        * 
* INpredicates whose IN operand is base column and IN          * 
* elementsarecomposed of only literals, DB2 query compiler can * 
* convertone ofthem to NLJOIN. It is possible that the         * 
* compiler converts asuboptimal IN predicate rather than the   * 
* optimal one. The fixmakes sure the converted IN predicate is * 
* the optimal one.Local fix: Use optimizer profile option      * 
* "<INLIST2JOINOPTION="ENABLE" TABLE="TABLE_NAME"              * 
* COLUMN="COLUMN_NAME"/>.Replace TABLE_NAME and COLUMN_NAME    * 
* with the real name of theINpredicate dedicated to DB2        * 
* compiler for attempting the IN toNLJOIN conversion.          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Fix pack 6                                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.12.2009
31.05.2010
31.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version