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 DBI 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
SEMMSLYou 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