SQLERR -25580, ISAM -54

Hello, Since a few days now, we regularly hear from users that their are disconnected from the database with error -25580, isam -54. Does anyone now what is the timeout after which Informix disconnects a session? Thanks in advance!!

Hi, there is no default timeout for sessions, unless you specify a method of disconnecting idle sessions intenally in IBM Informix. You did not mention what version you are, so we cannot tell you if this feature is available for your box. Errors 25580, 27001 are best related to external network services interrupted, than to Informix engine directly. Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: kvangompel@caami-hziv.fgov.be > Subject: SQLERR -25580, ISAM -54 [36438] > Date: Fri, 22 Jan 2016 08:17:24 -0500 > > Hello, > > Since a few days now, we regularly hear from users that their are disconnected > from the database with error -25580, isam -54. > Does anyone now what is the timeout after which Informix disconnects a > session? > Thanks in advance!! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Kurt: Version and platform are always helpful. On most platforms (but not all) errno 54 is "Connection reset by peer" which would indicate that Informix disconnected the user's session. That could be for several reasons, some obvious: 1. The engine bounced. 2. You have an idle session task running that disconnected it. 3. Someone ran an onmode -z for that session. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jan 22, 2016 at 8:17 AM, KURT VAN GOMPEL < kvangompel@caami-hziv.fgov.be> wrote: > Hello, > > Since a few days now, we regularly hear from users that their are > disconnected > from the database with error -25580, isam -54. > Does anyone now what is the timeout after which Informix disconnects a > session? > Thanks in advance!! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1141c1e027cc5f0529ec2eef

Hi, We found out that our internet service provider had configured a connection timeout recently without telling us. That's why our users were disconnected after some idle time. Thanks for your responses!!!