Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Unanswered: Informix Error -25588

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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
    ***********************************************

  3. #3
    Join Date
    Jan 2003
    Posts
    3
    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


    Originally posted by eherber
    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
    ***********************************************

  4. #4
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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
    ***********************************************

  5. #5
    Join Date
    Feb 2003
    Posts
    7
    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.

  6. #6
    Join Date
    Jan 2003
    Posts
    3
    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.

Posting Permissions

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