By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,925 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,925 IT Pros & Developers. It's quick & easy.

DB2 ODBC connection timeout???

P: n/a

DB2ers,

Our Windows application connects to any DB2 server using the ODBC
driver.

It seems there are two ODBC drivers that IBM provides - DB Connect and
DB2 Runtime Client. We have tested our product well with DB2 runtime
client and it seems to work great. However, one of our customers is
using DB Connect 7.1 as the ODBC driver. Although our product seems to
be able to connect to the server, query execution behavior is
inconsitent. Many times, it simply returns an error "the connection is
dead." We have not been able to figure out the pattern.

I have googled all over to see "the connection is dead" issue. One post
suggeted that DB Connect 8 with FixPack 3 fixes some issues. However, I
am wondering if anyone has any insight on why one could be getting this
problem.

Thank you in advance for your help.

Pradeep

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Just to clarify:
There is only one ODBC driver that IBM provides.

DB2 Connect is a piece of middleware to enable host connections. That
you need for any DB2 z/OS connection.
DB2 runtime client standalone cannot do that, only if you connect via a
DB2 Connect Server gateway.

We moved to DB2 Client V8 Fixpak 7 and did not encounter any problems
like that using a connect gateway.

The database you are connecting too: which version is it and is that on
z/OS or LUW ?
Your client code is based on V8 or V7 of DB2 ?
Remember:

For Version 8 client applications you will need a Version 8 DB2 connect
as well, it is not supported with V7 Connect.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.