Re: Multiple Residency & Shared Memory

jim lowry wrote: > > Guess each has their own way... 8-) I guess you mean each database vendor. That is true. > 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. An Informix database can be opened by any user who has privileges, that is true. > 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. That might be the case, but Informix databases allocate shared memory owned by root (or informix in older versions), NOT by users. So you cannot use that method of identification. If you have multiple Informix database servers, then the only way to identify shared memory is by calculating the addresses per server. If you have one Informix database server, but multiple databases, then they all share the same shared memory anyway. > Many factors go into how databases are started > and how shared mem is cleared. Yes, and you seem to have them confused. When you open an Informix database no shared memory is allocated. The segments allocated to the server are shared by all users. This is possibly where it gets it's name from. ;-) I am concerned that the novices (Informix DBA's that have been around less than 6 months :) on the list may be confused by your comments. Art has explained it, I have explained it, if you don't believe us, then you can browse the manuals for free. 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. |/ ////////| +----------------------+-----------------------------------+-----------+