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 | |
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 | |
9.7.0.3 |