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 IC66270 Status: Geschlossen

DB2 MAY ISSUE SQL0901N EXECUTING A QUERY WITH CORRELATED REFERENCES
TO A TABLE FROM AN OUTER JOIN

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
This APAR completes the fix for APARs IZ43786 or IC62688. 
The symptoms of this APAR may coincide with those of the 
aforementioned APARs; refer to them for more detail.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Any user issuing query affected by this issue.               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Summary:                                                     * 
*                                                              * 
* DB2 MAY ISSUE SQL0901N EXECUTING A QUERY WITH CORRELATED     * 
*                                                              * 
* REFERENCES TO A TABLE FROM AN OUTER JOIN                     * 
*                                                              * 
*                                                              * 
* Description:                                                 * 
* This APAR completes the fix for APARs IZ43786 or IC62688.    * 
*                                                              * 
* The symptoms of this APAR may coincide with those of the     * 
*                                                              * 
* aforementioned APARs; refer to them for more detail.         * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* LOCAL FIX:                                                   * 
*                                                              * 
* No workaround exists aside from manually rewriting the query * 
* in                                                           * 
* question.                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* recommended to move to V9.5 Fix pack 6.                      * 
****************************************************************
Local-Fix:
No workaround exists aside from manually rewriting the query in 
question.
verfügbare FixPacks:
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

Lösung
The issue was fixed in V9.5 Fix Pack 6.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68286 IC68287 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.02.2010
17.05.2010
17.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version