DB2 - Problem description
Problem IC82961 | Status: Closed |
DB2 may abend on a left outer join when the right table is UNION ALL view | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
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 | |
Problem Summary: | |
**************************************************************** * 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: | |
Solution | |
The fix will be included in db2_v91fp12 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC84117 IC84120 IC87845 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.04.2012 08.11.2012 08.11.2012 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.12 |