DB2 FOR LUW / DB2FORLUW / A50 - DB2

Compiling a query that has "distinct" keyword in intra_partition 
parallelism mode can result in the following SQL901N error: 
 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "Order cols removed from sort output cols.".) 
SQLSTATE=58004 
 
 
The stack includes the following functions 
 
sqlnn_erds 
sqlno_post_order_near_normalize 
sqlno_post_order_near_normalize 
sqlno_smp_test_create_part_from_key_order 
sqlno_smp_check_plan 
sqlnoSmpPlanPass

**************************************************************** 
* USERS AFFECTED:                                              * 
* intra_partition parallelism                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7                       * 
****************************************************************

There are two alternatives: 
- Turn off intra_partition parallelism for the entire instance: 
db2 update dbm cfg using INTRA_PARALLEL NO and restart the 
instance. 
- Turn off intra_partition parallelism only for the query by 
setting CURRENT QUERY DEGREE to 1.

First fixed in DB2 Version 10.5 Fix Pack 7

keiner bekannt / siehe Local-Fix

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

03.10.2015
19.01.2016
19.01.2016