DB2 - Problembeschreibung
Problem IT05898 | Status: Geschlossen |
WRONG RESULTS RECEIVED FOR A QUERY DUE TO INCORRECT INTERNAL COLUMN STRUCTURES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
The wrong result set may be outputted if the Optimizer chooses an Explain Plan with the following characteristics: - HSJN has an NLJN in the Outer - The NLJN has another HSJN in it's Inner - The second, HSJN also has an NLJN in it's Outer: HSJN( A) | --------------------------------------------------- | NLJN(B) / \ < other Lolepops like TEMP, etc> | HSJN(C) | ------------------ | NLJN(D) In a rare case, internal Optimization could create wrong internal structures and the Column coming from HSJN(C) Payload could return the same value as the last value that was processed in HSJN(C). | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5.0.5. * **************************************************************** | |
Local-Fix: | |
To avoid the problem, execute the following command and then recycle the instance: db2set DB2_TCG_DEFAULT_OPTIONS="set disable_pushdown on" | |
Lösung | |
The problem is first fixed in DB2 version 10.5.0.5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.12.2014 09.04.2015 09.04.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |