DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under rare scenarios, DB2 might produce SQL0901N error message 
if the following conditions are true: 
1. The query has an existential subquery 
2. The source of the subquery is a union/union all 
3. One or more branches of the union all refer to a table 
function 
 
<error message> 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "OID 
imbalance".) 
SQLSTATE=58004 
 
<stack> 
sqlnq_union_ofn_sm 
sqlnq_proc_enc 
sqlnq_qtb::add_doid 
sqlnq_sel_doid 
sqlnq_select_ofn_sm 
sqlnq_proc_enc 
sqlnq_qtb::add_doid 
sqlnr_addids 
sqlnr_EtoF_action 
 
Workaround: none

**************************************************************** 
* USERS AFFECTED:                                              * 
* QUERY WITH TABLES FUNCTIONS AND EXISTENTIAL SUBQUERY MIGHT   * 
* PRODUCE SQL0901N                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in fix pack 4 of DB2 v10.5                       * 
****************************************************************

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in fix pack 4 of DB2 v10.5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

26.09.2013
08.09.2014
08.09.2014