DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* Move to fix pack 4 of DB2 10.1                               * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Move to fix pack 4 of DB2 10.1

keiner bekannt / siehe Local-Fix

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

11.10.2013
02.06.2014
02.06.2014