Re: Multiple Residency & Shared Memory

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. > > That way you can "ipcs |grep <database owner name>" > > Start database 1 as db1 > Start database 1 as db2 > Start database 1 as db3 > > That way you can "ipcs |grep db2" > And run a script if needed to kill > only those for db2 > > Better than bringing down all 3 datbases > or re-booting the box. I almost get the feeling you are talking about another database vendor. A "database" in Informix terminology is a collection of related tables. A database server can store many databases. A "database server" has resources (processes, shared memory) allocated to it. If you DO configure more than one database server on the same machine, then it must be started by either root or informix and all resources will be owned by root and group informix. Up to version 5 the resources were owned by informix. I don't believe you CAN start the database server as any other user, but then I have never tried. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+