DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* V9.7 users fix pack2 and earlier                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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.    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to fix pack 3                                        * 
****************************************************************

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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
 

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.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

21.12.2009
24.09.2010
24.09.2010