DB2 FOR LUW / DB2FORLUW / 950 - DB2

Queries with ORDER BY and Outer Joins where the ON clause of 
some (or all) of the 
Outer Joins contains predicates of the form (1=0) or predicates 
that can be 
proved it is always false may return SQL1585N. Such queries 
requires the width of the rows, 
the sum of the length of all the columns in the SELECT clause, 
exceeding the largest pagesize 
of the system temporary tablespace.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Queries with ORDER BY and Outer Joins where the ON clause of * 
* some (or all) of the Outer Joins contains predicates of the  * 
* form (1=0) or predicates that can be proved it is always     * 
* false may return SQL1585N.                                   * 
* Such queries requires the width of the rows,                 * 
* the sum of the length of all the columns in the SELECT       * 
* clause,                                                      * 
* exceeding the largest pagesize of the system temporary       * 
* tablespace.                                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 9.5 fixpack 10.                   * 
****************************************************************

Remove unnecessary ORDER BY columns deriving from the right 
table of the LEFT OUTER JOIN 
(or the left table of the RIGHT OUTER JOIN) that contains the 
false predicate in the ON clause.

Problem was first fixed in DB2 UDB Version 9.5 FixPack 10.

not known / see Local fix

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

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

09.01.2012
22.08.2012
22.08.2012

9.5.FP10