DB2 FOR LUW / DB2FORLUW / A10 - DB2

The problem can occur if the optimizer chooses to 
intra-parallelize the plan. That is, the "Query Degree" shown in 
the query plan is greater than 1. 
 
This can be observed when an intra-parallelized plan is compared 
with a serial plan. The total cost of the intra-parallelized 
plan is much higher than its corresponding serial plan. 
 
For example: 
 
intra-parallelized plan: 
----------- 
    Total Cost:         1.30441e+21 
    Query Degree:       24 
 
 
serial plan: 
----------- 
    Total Cost:         1916.61 
    Query Degree:       1 
 
 
The cost difference doesn't affect query performance.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Intra-query parallelism                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 5.                      * 
****************************************************************

Fixed in DB2 Version 10.1 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

28.10.2014
16.07.2015
16.07.2015