INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

When a stored procedure contains a select with a connect by and
the server environment has a
DBSPACETEMP setting where multiple temp spaces are defined, the
second execution
of the stored procdure in the same session can cause an error
-243/102.

example query causing this error :

    SELECT distinct childid,parentid
    FROM sh_link x
       START WITH (x.childid = pid or x.parentid = pid)
              and (cardinality(include)=0 or type in include)
              and (cardinality(exclude)=0 or type not in
exclude)
       CONNECT BY NOCYCLE
                  (childid = PRIOR parentid or parentid = PRIOR
childid or childid = PRIOR childid or parentid = PRIOR parentid)
              and LEVEL

****************************************************************
* USERS AFFECTED:                                              *
* all users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.12.2016
10.07.2017
10.07.2017

12.10.xC9