Dear friends,

I encountered the above error when more than 32 users accessing the application. My onconfig.abc file has the following parameters:

DBSERVERNAME abc
DBSERVERALIASES abc_tcp
NETTYPE ipcshm,1,64,CPU
NETTYPE tlitcp,1,64,CPU
MULTIPROCESSOR 1
NUMCPUVPS 1
SINGLE_CPU_VP 1

I am running Informix application on:
- SUN Solaris 5.6 with 2xCPU, 1DB RAM
- Informix IDS: 7.24 UC6
- Informix 4GL: 7.20 UD2
- Currently slightly more than 32 concurrent users

I have read informix manual in order to find out if the above parameters had caused the above error, but not able to. Below are my questions:

1) Is the error -25577 caused by above parameters? If not, what causes it?

2) Do you recommend to increase NUMCPUVPS to 2 since I have 2 processors? Does it improve performance by doing so?

3) Can I have two different protocols (ipcshm & tlitcp) defined as same VP_class (CPU) but each protocol have 1 poll_threads, in fact, there is only one CPU VP?

4) What are the suggested parameters for best performance?

Thanks.

Best Regards

hercules:/apps/tetra/sys $ finderr 25577
-25577 Network driver cannot get a host structure.

A system call has failed. See the system administrator for assistance.


hercules:/apps/tetra/sys $

---

Is there a particularly crappy network card in the SUN box?

Hmm. You're using ipcshm - this is shared memory access, which is unusual when connecting from another machine. onsoctcp is what we use, so maybe try switching over (though hacking through etc/sqlhosts may be tricky).

Sorry, typo-error. It was error no. 25588.

hercules:/apps/tetra/sys $ finderr 25588
-25588 The appl process cannot connect to Dynamic Server <server-name>.

An error in the application can produce this message. Check your
CONNECT statement and the sqlhosts file. A system failure can also
produce this message. If you can find no immediate cause for the
failure, note the circumstances and contact your database server
administrator for assistance.

The shared memory communication subsystem is down or not functioning.
Contact the database server administrator to report the problem.


hercules:/apps/tetra/sys $


----
Anything in the online.log?

Personally, I'd move away from using a protocol that uses shared memory to at least eliminate that.

Excellent ! I like it very much