DB2 FOR LUW / DB2FORLUW / A50 - DB2

When the registry variable :  DB2_WORKLOAD=PUREDATA_OLAP  is 
set, a heuristic that is applied during query compilation can 
lead to error : 
 
SQL0901 Reason "Order cols removed from sort output cols." 
 
for statements that have no group by clause nor distinct 
aggregate and that use the min/max aggregate. 
 
This also only occurs in DPF or SMP environments. 
 
This particular problem does not happen in versions below V10.1 
Fix Pack 2.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or Later                                             * 
****************************************************************

enable this registry setting : 
db2set DB2_EXTENDED_OPTIMIZATION="ON,COMPLETE_GB,TQPERF 30"

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 DB2 Cancun Release 10.5.0.4 (also known as Fix 
Pack 4)

keiner bekannt / siehe Local-Fix

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

22.04.2014
13.10.2014
13.10.2014