DB2 FOR LUW / DB2FORLUW / 980 - DB2

To hit the problem, a query needs satisfy all the following 
characteristics: 
(1) Query has UNION ALL or LEFT OUTER JOIN construct. 
(2) Query has ORDER BY clause applied on the result of UNION ALL 
    or LEFT OUTER JOIN 
(3) At least two columns in ORDER BY clause are equivalent. 
(4) The Fetch First N rows clause is used. 
 
The problem symptom is one of two SQL0901N errors: 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason 
"this->qclqclord.pp() != 
NULL".)  SQLSTATE=58004 
 
or 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason 
"sqlno_int_order_opr_req 
[400]:rc(-2144272209) Sibling order r".)  SQLSTATE=58004 
 
An example query is 
select * from table (select * from t1 union all select * from 
t2) 
where c1 = 1 and c2 = 2 and c3 = 1 and c4 = 4 
order by c1, c2, c3, c4 
fetch first row only;

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL0901 error may be incorrectly returned for specific query * 
* conditions                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 server to V9.8 Fix Pack 4                    * 
****************************************************************

Remove the ORDER BY columns that equal to constants. 
Or change predicate "c3=1" to "c3=1.0".

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

This problem was first fixed in V9.8 Fix Pack 4

not known / see Local fix

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

10.02.2010
04.08.2011
04.08.2011

9.8.FP4