Hi,

Our system Sun 2.8 has 2 GB Ram. Right now I am running 8 informix instances. A requirement has come wherein I have to add 8 more instances !!

Is there any limit to the number of instances to be created?

Any suggestions will be appreciated.

Regards,
Ramesh

Holy !$#@ !!! Why do you have so many instances ? Are these test or production environments ? If this is production, how many concurrent users are using the current instances ? How big are the instances ? Remember, each instance cuts your resource pie significantly and that informix does not handle these separate shared memory segments efficiently.

Hi,

It is a test environment wherein we are trying to simulate 8 different production boxes each having two instances.

The number of users will not be more than 5 at a time for each instance.

I already have some instances going down all of a sudden.

How much memory would each instance occupy?

Thanks & regards,
Ramesh

The physical limit is 255.
I would advise to set them all to tcp connections, because shm could cause problems.
'onstat -' shows you the amount of memory allocated.
in yr $ONCONFIG, the parameters BUFFERS, SHMVIRTSIZE and SHMADD affect most of you mem.

Thankyou for your valuable suggestions.

Ramesh