Re: Informix and multiple instances

From: caf <caf0013@my-dejanews.com> >I'm the sysadmin at a HP/Informix site, and we are currently looking at >running many instances on the same platform. > >What I would like to know the advantages/disadvantages of doing this from >anyone who has experience with lots of instances. > >We are looking at 10 medium size instances > >SIZES (GB): 48 < range > 2 >USERS : 130 < range > 20 >all in one about 230GB, 700+ users > >And I would like to get a feel for the impact it will have on the system. > >I'm thinking that there will be major benefits by decreasing the loading on >the systables by dividing them up, also in giving the ability to restore a >particular instance to a different point in time (something impossible with a >dbspace in a single instance, and very necessary!) -- but it will increase >the "load" by increasing the number of processes doing database work (i.e. >oninit etc), and the contention for processor time. There was some discussion on this not too long ago. Check out dejanews or the iiug.org website for more details. I think the consensus was: don't do it -- it's better to reduce the number of instances on your server. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com