Archives of the TeradataForum
Message Posted: Wed, 09 Mar 2011 @ 15:03:45 GMT
Has anyone noticed the following - and do you know the cause / resolution ?
Using ODBC as the api, when the program disconnects from the dbms the session stays on the dbms for a few minutes (1-2 minutes). This is on a completely idle system apart from this one ODBC session and a second session which is there simply to monitor what is happening. Neither session is doing any processing.
I've tried this on two DBMS releases, 18.104.22.168 and 22.214.171.124.
I've tried this using ODBC drivers 126.96.36.199, 188.8.131.52 and 184.108.40.206.
I'm using SQL Assistant 220.127.116.11 as my odbc application.
If I connect using dot net data provider from the same SQL Assistant or using cli (Bteq, my own code etc) then the session disappears from the DBMS immediately.
It sounds like an ODBC bug to me but I thought I'd ask if anyone else has come across this yet.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|