|
Problem IC68271
|
Status: Closed |
SQL0901N MAY BE ISSUED IN A DPF ENABLED DATABASE COMPILING A QUERY CONTAINING AN IN LIST AND A CORRELATED SUBQUERY PREDICATE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
An SQL0901N may be issued during compilation or optimization of
a query that satisfies the following conditions:
1. Database is Data Partitioning Feature (DPF) enabled
2. The top-level block of the query is a SELECT statement
3. The query or one of its nested sub-selects contains an IN
list predicate
4. The query block containing the IN list predicate also
contains a correlated subquery predicate
5. The nested subquery block references a nickname |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 3 or later. *
**************************************************************** |
| Local Fix: |
The problem may be worked around by one of the following two
methods:
1. Including IN2JOIN_OFF in the value(s) specified for the
DB2_EXTENDED_IN2JOIN registry variable, e.g.,
db2set
DB2_EXTENDED_IN2JOIN=[<other-values>,]IN2JOIN_OFF[,
<other-values>]
Note that the instance will need to be recycled after applying
this change and consequently the impact of this setting will be
instance wide.
2. Explicitly enabling the old IN list optimization behaviour
via specification of the IN2JOIN Query Rewrite Guideline (in an
Optimization Profile) for a specific problematic query, e.g.,
<OPTGUIDELINES><INLIST2JOIN OPTION='ENABLE' /></OPTGUIDELINES> |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.05.2010
30.09.2010
30.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
