RE: Resident Memory larger then expected

Correction: I wanted to say: Accordingly SHMTOTAL is set ... I have a machine with only 4 GB of memory and I want to run two instances of IDS. It' s a Datawarehouse test installation. And I have to use HPL to load rather large tables. So I limited the kernelparamter for shared memory that is granted to one "project" to 1 GB (a quarter of total memory is default anyway). Accordingly SHMMAX is set to 1GB. I did all this because I had issues to start HPL on that machine with memory errors. BTW: I found in the fine manual that one lock takes about 100 to 200 Byte of shared memory and that it is placed initially in the resident portion and when added dynamically in the virtual portion. Thanks all for your help. Reinhard. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Art Kagel Sent: Friday, December 11, 2009 1:46 PM To: Habichtsberg, Reinhard Cc: Superboer; informix-list@iiug.org Subject: Re: Resident Memory larger then expected I haven't yet overrun SHMTOTAL on an 11.50 instance since I always set SHMTOTAL to zero (unlimited) now, but in the past, if the engine wanted more virtual memory and SHMTOTAL was exhausted, the instance shutdown or hung. I know that there was an old feature request for the instance to just keep going but error out whatever operation required the additional memory, but I don't know if that was ever implemented. The last time I hit the limit was in an early 7.31 instance. Art Art S. Kagel Oninit ( www.oninit.com <http://www.oninit.com>; ) IIUG Board of Directors ( art@iiug.org <mailto:art@iiug.org> ) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf <http://www.iiug.org/conf>; Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 11, 2009 at 7:42 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de <mailto:RHabichtsberg@arz-emmendingen.de> > wrote: Hello Superboer, good hint! I changed LOCKS from 4,000,000 to 10,000 and now only 49152 KB for the resident portion were allocated. What happens if the server allocates more locks in 1,000,000 portions as I have seen before and memory is limited to e.g. 1024000 KB (SHMTOTAL)? Regards, Reinhard. > -----Original Message----- > From: informix-list-bounces@iiug.org <mailto:informix-list-bounces@iiug.org> > [mailto: informix-list-bounces@iiug.org <mailto:informix-list-bounces@iiug.org> ]On Behalf Of Superboer > Sent: Friday, December 11, 2009 1:07 PM > To: informix-list@iiug.org <mailto:informix-list@iiug.org> > Subject: Re: Resident Memory larger then expected > > > Hello Reinhard. > > how many locks did you set in onconfig; this one will also be in the > resident portion > among other stuff. > > > In earlier versions of IDS the formular was BUFFERS x 2 = > Size in KB. I had... > > hmm not really earlier versions had also locks in resident also > logbuff and physbuf etc... > > Superboer > > On 11 dec, 12:55, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > emmendingen.de <http://emmendingen.de>; > wrote: > > Hi all, > > > > in onconfig I set > > > > BUFFERPOOL> > > size=2K,buffers=20000,lrus=8,lru_min_dirty=20.000000,lru_max_d > irty=30.000000 > > . > > > > In the message log I see: > > Memory sizes:resident:570368 KB > > > > In earlier versions of IDS the formular was BUFFERS x 2 = > Size in KB. I had > > expected memory size resident: 40000 KB. > > > > What's the reason for the difference and how can I handle it. > > > > IDS11.50FC5W4 in Solaris 10 > > > > TIA, > > Reinhard. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org <mailto:Informix-list@iiug.org> > http://www.iiug.org/mailman/listinfo/informix-list <http://www.iiug.org/mailman/listinfo/informix-list>; > _______________________________________________ Informix-list mailing list Informix-list@iiug.org <mailto:Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list <http://www.iiug.org/mailman/listinfo/informix-list>;