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

DB2 may abend on a left outer join when the right table is UNION ALL view

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
DB2 may abend when running or compiling a SQL statement contains 
 
a left outer join and the right table of the outer join is a 
UNION ALL view. 
 
Additional conditions are the left table is a table with a 
unique index (or a primary key) 
and the join predicate is on on the unique column of the left 
table. 
 
The call stack in the db2diag.log when this problem occurs may 
look like: 
 
sqlnq_oprhxpparent::op 
sqlnr_addids 
sqlnr_joinppd_magic_detail 
sqlnr_joinppd_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_magic_detail_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_endqtb_action 
sqlnr_comp 
sqlnr_start_action 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlricall 
sqlriSectInvoke
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 may abend when running or compiling a SQL statement      * 
* contains                                                     * 
*                                                              * 
* a left outer join and the right table of the outer join is a * 
* UNION ALL view.                                              * 
*                                                              * 
* Additional conditions are the left table is a table with a   * 
* unique index (or a primary key)                              * 
* and the join predicate is on on the unique column of the     * 
* left                                                         * 
* table.                                                       * 
*                                                              * 
* The call stack in the db2diag.log when this problem occurs   * 
* may                                                          * 
* look like:                                                   * 
*                                                              * 
* sqlnq_oprhxpparent::op                                       * 
* sqlnr_addids                                                 * 
* sqlnr_joinppd_magic_detail                                   * 
* sqlnr_joinppd_action                                         * 
* sqlnr_comp                                                   * 
* sqlnr_seq                                                    * 
* sqlnr_rcc                                                    * 
* sqlnr_magic_detail_action                                    * 
* sqlnr_comp                                                   * 
* sqlnr_seq                                                    * 
* sqlnr_rcc                                                    * 
* sqlnr_endqtb_action                                          * 
* sqlnr_comp                                                   * 
* sqlnr_start_action                                           * 
* sqlnn_cmpl                                                   * 
* sqlra_compile_var                                            * 
* sqlra_find_var                                               * 
* sqlra_get_var                                                * 
* sqlricall                                                    * 
* sqlriSectInvoke                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v91fp12                                       * 
****************************************************************
Local-Fix:
Lösung
The fix will be included in db2_v91fp12
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84117 IC84120 IC87845 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.04.2012
08.11.2012
08.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.1.0.12 FixList