Re: Informix 7.13 "eating" memory
Paul Leskinen wrote:
>
> I was hoping that someone out there has encountered this problem:
>
> We have an online transaction-processing application that stays resident
> and processes financial transactions using Informix. The problem is that
> Informix Online keeps allocating more and more shared memory for the
> process(es).
>
> We've actually seen the problem (on a smaller scale, of course) with the
> following ESQL/C code:
>
> main()
> {
> exec sql BEGIN DECLARE SECTION;
> decimal(10,0) institution;
> exec sql END DECLARE SECTION;
>
> int count;
>
> /* Get stuff ready */
>
> printf("opening database...\\n");
> exec sql database u_switch;
>
> /* Loop it */
>
> for(count=0;count<10000;count++)
> {
> exec sql select institution into :institution from device
> where device_id=13;
>
> printf("%d\\n",count);
> }
> exec sql close database;
> }
>
>
> The field names are not really important. When this program runs, we see
> the "file table" memory pool expand apparently without bounds. (We did an
> onstat -g ses xxx to obtain that information while the program is running).>
> One more note: When the program terminates, all shared memory allocated by
> Informix is freed. An obvious solution would be for our OLTP to terminate
> and restart once in awhile to avoid this problem--but that's kind of
> unsightly behavior for a "continously" available application.
>
> We're running version 7.13.UC1 of Online Dynamic Server on an NCR 3430 dual
> Pentium running UNIX MP-RAS 2.03.00. We have ESQL/C ver. 7.13.UC1.
>
> We've been going back and forth with Informix tech support for awhile with
> no luck so far.
>
> We're now behind schedule thanks to this little problem. Any help would be
> greatly appreciated.
>
> Paul Leskinen
> Consolidated Systems of Florida
I do an onmode -F every hour to free up memory from cron.