INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Usually the scheduler has 3 sessions, 1 for the scheduler thread
and usually 2 for the worker.
Attached to the sessions are the session memory and usually
several EXE memory pools depending
on how may statements are opened. The initial state for the EXE
memory pools is

$> onstat -g mem | grep EXE |  awk ' { print $1 } ' | uniq -c
      2 EXE.31.94
      4 EXE.32.95
      4 EXE.33.96

Given the sysadmin database tables see an update statistics by
the AUS, or there is another reason why
the cached statements in the scheduler sessions has to be
reprepared. After each reprepare the amount
of EXE memory pools is growing.

$> onstat -g mem | grep EXE |  awk ' { print $1 } ' | uniq -c
     12 EXE.31.94
     20 EXE.32.95
     21 EXE.33.96
$> onstat -g mem | grep EXE |  awk ' { print $1 } ' | uniq -c
    114 EXE.31.94
    173 EXE.32.95
    174 EXE.33.96
$> onstat -g mem | grep EXE |  awk ' { print $1 } ' | uniq -c
    154 EXE.31.94
    244 EXE.32.95
    236 EXE.33.96

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC10. *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC10.         *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC10. *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC10.         *
****************************************************************

Fixed in Informix Server 12.10.xC16 and 14.10.xC10.

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

03.03.2022
15.05.2023
15.05.2023