Re: Informix 7.13 "eating" memory
In article <01bbcbf4$d80537e0$2186e4ce@pc33.csfi.com>, Paul Leskinen
<paul@csfi.com> writes
>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).>
Are you sure nothing else is running against the Online server at the
same time? It not it sounds like a bug.
>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.
>
You could try running onmode -F to free unused shared memory. This
might not help but is worth trying. Do an onstat -g seg before and
after an see if the 'free column' increased anywhere or even if some
complete segments get freed!
>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.
>
I've got Online 7.12 and 4GL 6.02 (which can compile ESQL/C) at work,
I'll try the program above on Monday and let you know what I find.
>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
>
--
David Williams