Archives of the TeradataForum

Message Posted: Mon, 01 Apr 2002 @ 16:37:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sid,

The DBCEndQuery command does NOT terminate the transaction, it simply tells cli and the dbms to terminate processing for that request. This may involve releasing spool files and will typically involve cleaning up cli memory. The dbms will only release locks IF the dbms knows this request is also the end of a transaction.

So in your scenario, -- if there is a system crash between steps 2 and 3, the dbms will rollbackto prior to step 1.

Teradata has no built-in timeout for automatically aborting sessions based on 'no activity' (this feature is included within Teradata Manager -- but that is an application working out who has been idle, not the dbms).

As far as I'm aware, the only time the dbms will check that clients are still there is following a restart. The dbms will check it's session info table and start a timer. If the client system for a particular client has not responded by the time the timer expires, it is assumed that the client has died and the sessions will be cancelled. That's my understanding but I may be of course a little (or a lot?)

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>