Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Error -25587 using a shared memory connection.

    Posted Wed December 18, 2024 06:28 AM

    Hello everyone.
    I was trying to run some heavy Genero 4GL jobs on the DB server via a shared memory connection.

    Some ran fine but other jobs crashed almost immedately (while in a cursor loop) with error

    $ finderr -25587
    -25587    Network receive failed.

    A system call has failed. Perform a DISCONNECT and then check the
    status of the server. See the system administrator for assistance.

    What does this mean when using a shmem connection? 
    It looks like the application was disconnected?

    Thx in advance,
    -S



    ------------------------------
    Snorri Bergmann
    ------------------------------


  • 2.  RE: Error -25587 using a shared memory connection.

    Posted Wed December 18, 2024 07:23 AM
    Anything in online.log ?


    MARCUS HAARMANN






  • 3.  RE: Error -25587 using a shared memory connection.

    Posted Wed December 18, 2024 07:30 AM

    No, nothing in online.log.



    ------------------------------
    Snorri Bergmann
    ------------------------------



  • 4.  RE: Error -25587 using a shared memory connection.

    Posted Wed December 18, 2024 07:58 AM

    Weird, and 25587 apparently being a rare error.

    Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)?



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------



  • 5.  RE: Error -25587 using a shared memory connection.

    Posted Wed December 18, 2024 08:35 AM

    Thanks Andreas.
    No, there are no signs of onmode -z and there are no session limits whatsoever.

    I am now running one job locally via onsoctcp. It seems much faster than from a different client machine.
    Will I see major performance benefits with shared mem compared to that?



    ------------------------------
    Snorri Bergmann
    ------------------------------



  • 6.  RE: Error -25587 using a shared memory connection.

    Posted Thu December 19, 2024 04:42 AM

    Just in case, check if you've defined QUERY_TIMEOUT environment session option. This can close sessions automativaly.

    QUERY_TIMEOUT session environment option

    Ibm remove preview
    QUERY_TIMEOUT session environment option
    Use the QUERY_TIMEOUT environment option of the SET ENVIRONMENT statement to limit the amount of clock time a query may take before being interrupted internally.
    View this on Ibm >



    ------------------------------
    Vicente Salvador Cubedo
    Software Architect
    DEISTER, S.A.
    Barcelona
    +34 932063298
    ------------------------------



  • 7.  RE: Error -25587 using a shared memory connection.

    Posted Thu December 19, 2024 04:59 AM

    Thanks Vicente.

    No, this parameter is not set at all. 

    Regs,

    -S



    ------------------------------
    Snorri Bergmann
    ------------------------------



  • 8.  RE: Error -25587 using a shared memory connection.

    Posted Wed December 18, 2024 08:18 AM
    Can you onmode -I 25587 ?

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC