Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 31 Mar 2002 @ 05:57:06 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Question on atomicity in CLI
From:   Sid Gudes

Hi All,

If I issue the following sequence via CLI:

1)      DBCquery:
                update ... ;

2)      DBCendQuery

3)      DBCquery:
                update ...;

4)      DBCendQuery

What happens if there is a system crash (network failure, client crashes) between steps 2 and 3? Will the transaction be rolled back because there was no "et;" generated? Or does DBCendQuery issue an implicit "et;", so the transaction will not be atomic? (We have to break up the transaction this way because there are too many Updates and we get out-of-memory errors on the server.)

If there is a rollback, how does Teradata determine when to do the rollback, i.e. when does it "realize" that there will be no further calls from the client (calls 3 and 4 above) and it rolls back what it did in steps 1 and 2?


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