Informix - Problembeschreibung
Problem IT02454 | Status: Geschlossen |
DYNAMIC HASH JOIN INVOLVING TS VIRTUAL TABLE CAN CONSUME GBS OF MEMORY IN RTN POOL WHEN SQL_FEAT_CTRL CONTAINS 0X800000 | |
Produkt: | |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 | |
Problembeschreibung: | |
If you have a TimeSeries virtual table (TS VT) constructed over TS data created using TS 5.00 (Informix 11.70) and the SQL_FEAT_CTRL parameter in your onconfig file contains the value 0x800000 (enable hash joins on VTI tables; introduced in 12.10.FC3W1), the dynamic hash join involving that TS VT can consume gigabytes of memory in RTN* memory pool related to the session. Having more such joins running at the same time (for example various Cognos reports) can exhaust all the available memory in the system. The problem is usually seen when the query runs from a Java/JDBC client. Running the same query in dbaccess doesn't show this behavior. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * users of ts data upgraded from a release before 12.10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.06.2014 16.10.2015 16.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
12.10.xC5 |
![]() |
12.10.xC5.W1 |
![]() |