DB2 - Problembeschreibung
Problem IT10953 | Status: Geschlossen |
ADDITIONAL FIX ON TOP OF APAR IT07926 (CARTESIAN JOIN PREDICATES) | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Performance may be poor for queries involving COLUMN ORGANIZED table that are referenced by cartesian join predicates. This APAR will fix additional issues encountered on top of APAR IT07926 (see this APAR for more details). This APAR is applicable when there are large number of joins causing optimizer to drop to greedy join enumeration. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.08.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |