I am getting the ISQL Error -25588 when trying to access the database on a Unix machine. I have two executables that attempt to open the database the same way. One produces the problem and the other does not. I am attempting to use shared memory exclusively. This problem did not occur when using TCP connections. It began to occur only when I modified the onconfig and sqlhosts files to setup Informix to use shared memory exclusively. Can anyone please help? Thank you.

Are the two executables compiled with the same
version of the Informix CSDK ?

It may be an issue with version compatibility.

What platform and which Informix versions are
you talking about ?
What kind of applications are this (esql/c) ?
Is there anything in the online.log ?



Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

1) Are the two executables compiled with the same version of the Informix CSDK?
-- Yes

2) What platform and which Informix versions are you talking about?
-- Sun Solaris 2.7
-- Informix 7.31

3) What kind of applications are this (esql/c) ?
-- Yes (esql.c)

4) Is there anything in the online. log ?
-- Nothing relevant to the error code. Just the Informix startup logs.

I believe it to be something with the shared memory access but am baffled as to what it is. I am not sure if modifying the system shared memory parameters would help or not. I am not that familiar with shared memory enough to know whether the systems parameters need tweaking or not. What about an executable determines how much shared me ory it needs for DB access

1) Post your sqlhosts-File and your onconfig
DBSERVER/DBSERVERALIASES settings

2) Check the value of your $INFORMIXSERVER environment
variable
Do the esql/c programs use the standard $INFORMIXSERVER
or have they hardcoded the databaseservername in the
connect-string ?

3) Are both programs dynamically or statically linked ?

4) To be absolutely sure, re-compile your programs with the
same CSDK-Version on the same solaris release

5) You might also tune the NETTYPE parameter in your
onconfig for shm-connections , for example:

NETTYPE ipcshm,1,200,CPU

There is a limit of about 50 shm connections if you don't adjust
the NETTYPE parameter. For TCP-connections this is dynamic.


Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

Check the modules on Solaris that Informix shared memory needs.

As root, enter the command : sysdef
this will give you a list of the system settings; near the bottom of the list should be an entry for IPC semaphore module, IPC shared memory module, and the shared message module, if one or all of these are not loaded , the listing will indicate this.

Please reply and paste the listing if you could.

All,
Thank you for your help but I have decided to upgrade Informix and that allowed me to use the TCP database connection. This is working. Again thank you for all your inputs.