DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* users with DB2_WORKLOAD=PUREDATA_OLAP set                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade the database server to V10.1 Fix Pack 4              * 
****************************************************************

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

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

This problem has first been fixed in V10.1 Fix Pack 4

keiner bekannt / siehe Local-Fix

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

04.09.2013
26.06.2014
26.06.2014