Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Socket Closed / connection link failure to DB2 database

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

Sign your company up to try the MB 660 headset now

Take control and stay focused in noisy open office environments with the MB 660. By reducing background noise, you can revitalize your office and improve concentration.

Question has a verified solution.

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

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
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…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

772 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