home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC69515 Status: Geschlossen

EXECUTION OF SQL STATEMENT WITH DBPARTITIONNUM IS NOT
PARALLELIZED FOR CERTAIN SCENARIOS IN DPF

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
This issue only applies if you are using the database 
partitioning feature (DPF). 
 
SQL statements that include an order on DBPARTITIONNUM or an 
OLAP function that includes DBPARTITIONNUM in the partition by 
clause are not parallelized, executing on a single database 
partition in the partition group.  The following are examples 
that illustrate the two scenarios: 
 
1.  order on DBPARTITIONNUM 
 
select dbpartitionnum(y), x from t order by 1; 
 
2.  DBPARTITIONNUM in PARTITION BY clause 
 
select max(x) over (partition by dbpartitionnum(y) order by 1) 
from t;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using the database partitioning feature (DPF) are      * 
* affected.                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This issue only applies if you are using the database        * 
*                                                              * 
* partitioning feature (DPF).                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* SQL statements that include an order on DBPARTITIONNUM or an * 
*                                                              * 
* OLAP function that includes DBPARTITIONNUM in the partition  * 
* by                                                           * 
* clause are not parallelized, executing on a single database  * 
*                                                              * 
* partition in the partition group.  The following are         * 
* examples                                                     * 
* that illustrate the two scenarios:                           * 
*                                                              * 
*                                                              * 
*                                                              * 
* 1.  order on DBPARTITIONNUM                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* select dbpartitionnum(y), x from t order by 1;               * 
*                                                              * 
*                                                              * 
* 2.  DBPARTITIONNUM in PARTITION BY clause                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* select max(x) over (partition by dbpartitionnum(y) order by  * 
* 1) from t;                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 3                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in version 9.7 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC69825 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.06.2010
23.09.2010
23.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList