Re: Multiple Residency & Shared Memory
> > > > Guess each has their own way... 8-) > >I guess you mean each database vendor. That is true. Each company vendor or user. > > > 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 out expanding.. yes > > > 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. when a used "db_owner_1" starts a database, you can follow it when using "ipcs" Anyone can be setup to be the owner of a database. > >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. wrong > > > 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. ;-) Beg to differ but the one who appears confused is you. It is people who are unable to think outside the box that believe there is only one way to do things. For a given project, I was forced to run 4 databases using 4 different names owned by 4 different id's. Ver 7.23 on a 6000 Sun box with 750 gig, 12 cpus and 8 gig of mem. But I'm sure your databases are just as big if not bigger. > >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. Please excuse my concern, but maybe you should... have a great day. > >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. |/ ////////| >+----------------------+-----------------------------------+-----------+ > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com