|
Problem IT02322
|
Status: Geschlossen |
Performance enhancement for a single partition table in a DPF environment. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
Performance issue may be found in an environment if following
conditions are true:
1. The environment is run in Database Partitioning Feature (DPF)
mode
2. All referenced tables in the execution are local.
2. Two way join where one table has replicated
Materialized Query Table (MQT) on non-coordinator node
3. Two-way join with MQT partitioned where partial data is
in coordinator node |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 V10.5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to DB2 V10.5fp5 *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
DB2 V10.5fp5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 06.06.2014
22.12.2014
22.12.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.5
|
 |
