|
Problem IC93193
|
Status: Closed |
AN OUTER JOIN ON A UNION ALL VIEW MIGHT RESULT IN SQL1585N ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
An optimization of moving an outer join operation under a UNION
ALL view
might result in SQL1585N error when all the following conditions
are met:
1. The UNION ALL view is referenced after the LEFT OUTER JOIN
keyword, or,
before the RIGHT OUTER JOIN keyword.
2. The other table of the OUTER JOIN operation produces output
columns
of LOB data types or whose combined length exceeding the
maximum
page size of a system temporary table. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users on V10.1 Fp1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.1 fp3 *
**************************************************************** |
| Local Fix: |
Issue the following command:
db2set DB2_UNION_OPTIMIZATION=DISABLE_OJPPD_FOR_NP -im
The problem is alleviated by bypassing this optimization in new
connections to the database. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95481 IC95482
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2013
01.10.2013
01.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
