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 IC71596 Status: Closed

CALCULATION ERROR IN CHECKS LEADING TO TOO MANY JOINS BELOW UNION ALL

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
A calculation problem affects UNION ALL join UNION ALL scenario. 
There is a calculation error in the checks which leads to a 
scenario of not detecting too many joins below the UNION. 
 
 
You can workaround this problem by reducing the 
MAX_JOINS_IN_UNION parameter to a set value and/or reducing the 
query optimization level to 0 or 1.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 users V9.5 FP7 and below                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* There is a calculation error in the checks which leads to a  * 
* scenario of not detecting too many joins below the UNION.    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V9.5 FP8 or use work around by         * 
* reducing the MAX_JOINS_IN_UNION parameter to a set value     * 
* and/or reducing the                                          * 
* query optimization level to 0 or 1.                          * 
****************************************************************
Local Fix:
(i) db2set DB2_UNION_OPTIMIZATION='MAX_JOINS_IN_UNION <value>' 
 
(ii) You could also reduce the optimization level that the query 
is compiled with to 0 or 1
available fix packs:
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
This fix is first available in DB2 V9.5 FP8
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71600 IC71601 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.09.2010
30.06.2011
30.06.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList
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.