DB2 FOR LUW / DB2FORLUW / 970 - 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 9                                    * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

See Error Description

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC96363 IC96822 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

29.03.2013
08.01.2014
08.01.2014

9.0.