Solved

Socket Closed / connection link failure to DB2 database

Posted on 2014-07-23
3
530 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

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-…
An article on effective troubleshooting
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
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…

752 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