Technical article 118121

Attempting to connect multiple users to my Informix database on OpenServer is failing with an error "25588: Cannot connect to DB".

OpenServer 5.0.5OpenServer 5.0.6

Written · Last revised

Problem

There is an application that attempts to connect to the Informix 7.31
Database I have on my OpenServer 5.0.x machine.  It will only allow me
to connect with a certain number users until it fails with an error
message similar to:
25588: Cannot connect to DB

I wish to increase the number of users that can attach to this database.

Cause

Your system is not tuned properly for Informix use.  The Semaphore
kernel parameters need to be specifically tuned for the volume of
users you wish to have use this database.

Solution

The proper values for all kernel parameters will vary from system to
system.  Please read the Informix release notes on what values your
kernel parameters must be set to.
There are 3 of the kernel parameters that must be tuned to increase
Semaphore limits.  There are other parameters to increase, but these
three must be tuned to achieve the desired results.
These parameters are:
SEMMNU
SEMUME
SEMMSL

You can use the /etc/conf/bin/idtune to tune these parameters. Once again, the Informix release will specify the proper values for these parameters based upon how many users you wish to have.

Please see Technical Article #110836, "OpenServer 5, How to change
the Semaphore  Kernel Parameters on SCO OpenServer systems." for
instructions on how to tune these kernel parameters properly on your
system.

See also

ta #110836, "How to change the Semaphore Kernel Parameters on SCO OpenServer systems."

Manual pages: idtune(ADM), stune(F), mtune(F)
SCO OpenServer Performance Guide

From the Xinuos technical article database, record 118121. Reproduced with permission. The original is at www.sco.com/ta/118121, which is reachable but blocked from search engines.

Next step

Need this fixed rather than explained?

Tell us the release, what the system runs and what it is doing. We will reply by email with what we would do next.

  • You deal with the people who do the work
  • No obligation, and no upgrade required before we will help
  • We tell you plainly if something is not worth doing

Send an enquiry

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.