Solved

Socket Closed / connection link failure to DB2 database

Posted on 2014-07-23
3
504 Views
Last Modified: 2014-09-17
Hi

I am running an application in Windows XP mode on Windows 7 that uses an ODBC connection to a remote DB2 database.  This has been working fine but now we are getting socket closed and connection link closed errors if users leave the application for a few minutes and then return.  How can I troubleshoot this issue and determine the cause of the timeout if thats the issue?
0
Comment
Question by:Trevor Coen
3 Comments
 

Author Comment

by:Trevor Coen
ID: 40214605
DataDirect Shadow for ODBC version 7.2 is being used as the ODBC driver
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 40214716
perhaps a dba turned on a timeout parameter on the db2 end
i would search the connection string parameters, maybe it's possible to specify a different timeout than the default one

other approach would be to change the application and make it handle such a problem by reconnecting
0
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 40237642
Hi!

Did you change anything in the network ? New switch, load balancer or some network config change ?
This could (as momi_sabag says) be a timeout setting on the db2 server side (if the dba changed it).

Regards,
    Tomas Helgi
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question