Thanks Vicente.
Original Message:
Sent: Thu December 19, 2024 04:42 AM
From: Vicente Salvador Cubedo
Subject: Error -25587 using a shared memory connection.
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
Original Message:
Sent: Wed December 18, 2024 08:34 AM
From: Snorri Bergmann
Subject: Error -25587 using a shared memory connection.
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
Original Message:
Sent: Wed December 18, 2024 07:58 AM
From: Andreas Legner
Subject: Error -25587 using a shared memory connection.
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
Original Message:
Sent: Wed December 18, 2024 06:27 AM
From: Snorri Bergmann
Subject: Error -25587 using a shared memory connection.
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
------------------------------