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, 188.8.131.52 and 184.108.40.206.
I've tried this using ODBC drivers 220.127.116.11, 18.104.22.168 and 22.214.171.124.
I'm using SQL Assistant 126.96.36.199 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: 23 Jun 2019|