?
Solved

Socket Closed / connection link failure to DB2 database

Posted on 2014-07-23
3
Medium Priority
?
594 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 2000 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 26

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
Not everyone has adapted to a rapid advancement in technology; there are people who are reluctant or afraid to delve into this brave new world of IT. If you have a friend or a family member who suffers from the so-called technophobia, here is how yo…
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…
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…
Suggested Courses
Course of the Month7 days, left to enroll

593 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