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