Dead Connection Detection (DCD)

[nshen]

We have observed dead CLI connections left on the server side after the CLI application freed the connection handles.
Is there a connection attribute, CLI, database, or DBM configuration parameter that need to be set in order to have the DB2 server free the dead connections? This happens when DB2 server is under the stress test. DB2 Servers are V7 fixed pack 8, across all operating systems.

I have seen an append in another DB2 user forum that mentioned this DCD is not implemented until DB2 UDB Version 8. But I could not confirm that from IBM. Has anyone heard about this?

Thanks!
Regards, Nancy

 

[tbt102]

I have a similar issue and believe this issue has been resolved in DB2 UDB AIX fixpak 9. Its log in APAR IY37745. Unfortunately FP9 is not yet available for download. However, I'm told that it may be possible to get relief before the release by opening a PMR with the Support Line and see if we are candidates for a special build.

 

[nshen]

It turned out that the orphaned connections on the DB2 Server side would disappear in exactly 10 minutes.
However, in our simulation of network down test case, the CLI connections on the DB2 client side would stay for exactly 2 hours (tcp/ip KEEPALIVE default), regardless the CLI QUERYTIMEOUT and SQL_ATTR_QUERY_TIMEOUT settings.

Has any CLI/ODBC programmer run into this situation before?
Regards, Nancy