Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Question on atomicity in CLI
From:   David Wellman


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?)



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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023