Re: Multiple Residency & Shared Memory

Guess each has their own way... 8-) A database (not engine) may be started by a user other than Informix depending on the application, how it was designed and what it was designed to do. With a rather large company (lets say the mouse) and limited resources (dba's that have been around longer then 6 months) it is easier to remove shared mem by owner. And that way you would not need to be calculating an instances shared memory. Many factors go into how databases are started and how shared mem is cleared. >From: "Art S. Kagel" <kagel@bloomberg.net> >Reply-To: kagel@bloomberg.net >To: jim lowry <lowryjim@hotmail.com> >Subject: Re: Multiple Residency & Shared Memory >Date: Wed, 31 May 2000 11:45:55 -0400 > >jim lowry wrote: > > > > When using "ipcs", it is easier > > and quicker to see each database > > if each database is started by > > a different owner... Also it > > makes it easier to remove (kill) > > a single database shared memory. > >The engine should ALWAYS be started either by user informix or root and it >MUST be started by root or a member of group 'informix' which should have >ONLY ONE member, informix. > > > That way you can "ipcs |grep <database owner name>" > > > > Start database 1 as db1 > > Start database 1 as db2 > > Start database 1 as db3 > >I record the shared memory key of each server on the last line of that >instance's ONCONFIG file so I have it at hand. I think that it is no >harder >to do: > >ipcs | fgrep 565e > > > That way you can "ipcs |grep db2" > > And run a script if needed to kill > > only those for db2 > >Note that ALMOST ALWAYS onmode -ky will kill the shared memory segments for >the current INFORMIXSERVER even if the instance has crashed and is offline. >That's easiest of all. > > > Better than bringing down all 3 datbases > > or re-booting the box. > >Check the tread above about calculating an instances shared memory key base >value and you will never have to reboot for this again. > >Art S. Kagel > > > >From: tslusser@bigfoot.com > > >Reply-To: tslusser@bigfoot.com > > >To: informix-list@iiug.org > > >Subject: Re: Multiple Residency & Shared Memory > > >Date: Tue, 30 May 2000 20:12:48 GMT > > > > > >Thanks! I believe I have it working now. > > > > > >In article <39339DD0.43D97E2@home.com>, > > > Edward Rosenthal <edrosenthal@home.com> wrote: > > > > your two instances won't share the same memory space,or segments. > > > > after you bring your second instance up you can see which 'keys' > > > > belong to the memory segments : ipcs -a | grep informix > > > > will show which memory your os has allocated for each instance. > > > > too many segments listed will indicate you need to reconfigure the > > > > total first segment size, and possibly the additional segments if > > >needed. > > > > Probably the main consideration is how much mem your box has in >toto, > > > > and how much it needs for other applications and overhead . > > > > > > > > tslusser@bigfoot.com wrote: > > > > > > > > > > > > >Sent via Deja.com http://www.deja.com/ > > >Before you buy. > > > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com