home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC93193 Status: Geschlossen

AN OUTER JOIN ON A UNION ALL VIEW MIGHT RESULT IN SQL1585N ERROR

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
verfügbare FixPacks:
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

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC95481 IC95482 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.06.2013
01.10.2013
01.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList