Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC68083 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 / 950 - DB2
Problem description:
An SQL0901N may be issued during compilation or optimization of 
a query that satisfies all of 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 Customers using DPF                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 6 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.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

Solution
First fixed in DB2 Version 9.5 Fix Pack 6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC68271 IC68278 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.04.2010
14.06.2010
14.06.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.