Solved

Socket Closed / connection link failure to DB2 database

Posted on 2014-07-23
3
493 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

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

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

We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
This is the first one of a series of articles I’ll be writing to address technical issues that are always referred to as network problems. The network boundaries have changed, therefore having an understanding of how each piece in the network  puzzl…
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now