home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList
12.10.xC5.W1 FixList