Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Location
    INDIA
    Posts
    24

    Question Unanswered: Maximum Number Of Instances In A System

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    INDIA
    Posts
    24
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  5. #5
    Join Date
    Aug 2002
    Location
    INDIA
    Posts
    24
    Thankyou for your valuable suggestions.

    Ramesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •