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

IN2JOIN OPTIMIZATION GUIDELINE IS NOT APPLIED TO REWRITE IN PREDICATE TO A
JOIN

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In certain conditions, DB2 does not apply the IN-LIST-to-join 
query 
rewrite when the optimization guideline IN2JOIN is specified. 
 
For example: 
 
In the SQL statement below 
 
SELECT ... 
FROM    PARTS P, SUPPLIERS S, PARTSUPP PS 
WHERE P.PARTKEY = PS.PS_PARTKEY 
AND      S.S_SUPPKEY = PS.PS_SUPPKEY 
AND      P_SIZE IN (?, ?, ?, ...) 
AND      ... 
 
and an optimization guideline 
 
<OPTGUIDELINES><INLIST2JOIN TABLE='P' 
COLUMN='P_SIZE'/></OPTGUIDELINES> 
 
is specified. The statistics information of the table P and the 
columns in the table are not sufficient to indicate that the 
IN-LIST-to-join will outperform other optimization techniques. 
However, when the optimization guideline IN2JOIN is specified, 
DB2 should apply the optimization regardless of the outcome from 
the analysis of the statistics information.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP9                                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 V9.7 FP9
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC91788 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.02.2013
17.12.2013
17.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList