IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10

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.

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

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.06.2014
16.10.2015
16.10.2015