Informix - Problembeschreibung
Problem IT09620 | Status: Geschlossen |
HASH JOIN ON A COMPLEX QUERY CAN YIELD TO MASSIVE PERFORMANCE PROBLEMS OR BLOCK THE ENGINE | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
When running a dss query which is doing some complex aggregate functions, the sqlexec thread does not yield often enough. This can lead to massive performance issues or block the engine. How massive the issue is depends on where the sqlexec thread is running. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users having DSS queries without PDQ and aggregate * * operations. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.06.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |