Excessive number of oninit processes

I have an Informix Online Workgroup Server 7.12.UC1 with 7 very small databases running on Solaris 2.5.1 (Sparc). When the database starts up, it spawns 25 oninit processes that each use up 17MB of RAM. As time goes on, these processes grow in size up to about 22MB each. Only one or two of these processes are getting any CPU time. I am running into memory/swap space problems on this machine. Why are there so many of these processes? How do I get rid of some of them? Can I remove some while the database is running? Can I make it so that so many do not get created when the database starts up? If possible, please include a reply to tauren@groovee.com. Thanks for the help! Tauren

Tauren Mills wrote: > > I have an Informix Online Workgroup Server 7.12.UC1 with 7 very small > databases running on Solaris 2.5.1 (Sparc). > > When the database starts up, it spawns 25 oninit processes that each use up Note: The oninit processes uses shared libraries. The don't need 25 * 22 MB Memory ! > 17MB of RAM. As time goes on, these processes grow in size up to about 22MB > each. Only one or two of these processes are getting any CPU time. Normaly about 7-10 oninit proccesses are running (onstat -g glo). Change the NUMAIOVPS Onconfig-Parameter to 1 or 2 (standard is " " which means 6 or (number of chunks * 2); whichever is greater) If kernel asyc. IO (kio) is used (onstat -g iov) one AIO vp is enough. > > I am running into memory/swap space problems on this machine. Why are there If this is a production machine: order more Memory (RAM) ! > so many of these processes? How do I get rid of some of them? Can I remove > some while the database is running? Can I make it so that so many do not > get created when the database starts up? > > If possible, please include a reply to tauren@groovee.com. > > Thanks for the help! > Tauren Hope this helps. Markus

Use onstat -g ioq to ensure that you are using KAIO (you'll see kio entries in the I/O queue table). If you are, then set NUMAIOVPS=1 for your servers - this is all you need when using KAIO. Neil Truby Londis Stores Hampton Hill, UK Tauren Mills wrote in message ... >I have an Informix Online Workgroup Server 7.12.UC1 with 7 very small >databases running on Solaris 2.5.1 (Sparc). > >When the database starts up, it spawns 25 oninit processes that each use up >17MB of RAM. As time goes on, these processes grow in size up to about 22MB >each. Only one or two of these processes are getting any CPU time. > >I am running into memory/swap space problems on this machine. Why are there >so many of these processes? How do I get rid of some of them? Can I remove >some while the database is running? Can I make it so that so many do not >get created when the database starts up? > >If possible, please include a reply to tauren@groovee.com. > >Thanks for the help! >Tauren > > >

Hi! My guess is that you have left NUMAIOVPS to blank. As mentioned by the great Art Kagel, strange things have been reported happening if you set this paramater to blank. Like Online spawning large AIO VPs. I've seen it. Zandy In article <T1uA2.1310$LO6.3180@news7.ispnews.com>, "Tauren Mills" <tauren@groovee.com> wrote: > I have an Informix Online Workgroup Server 7.12.UC1 with 7 very small > databases running on Solaris 2.5.1 (Sparc). > > When the database starts up, it spawns 25 oninit processes that each use up > 17MB of RAM. As time goes on, these processes grow in size up to about 22MB > each. Only one or two of these processes are getting any CPU time. > > I am running into memory/swap space problems on this machine. Why are there > so many of these processes? How do I get rid of some of them? Can I remove > some while the database is running? Can I make it so that so many do not > get created when the database starts up? > > If possible, please include a reply to tauren@groovee.com. > > Thanks for the help! > Tauren > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own