Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 27 Aug 1999 @ 15:29:53 GMT

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

Subj:   Re: How to stop or avoid Rollback or recovery process
From:   John Grass

This makes sense when you think about it. If you are updating an existing table (via update, insert or delete) and kill the update, Teradata is going to guarantee that the table will be recovered to its original state -- even across restarts.

One technique you can try is to design the queries to only insert rows into empty tables. In this case, Teradata will not log or go through a rollback, as Teradata knows that the original state of the target table is "empty."

If you have multiple steps that need to insert rows into the same table, you can either put all these steps into one multistatement request, or you can run multiple steps -- each inserting rows into their own empty table, consolidating the results at the finish.

If you have a need to update rows in the target table then you are going to have to live with the rollbacks. There is no way that I know of to "turn off" logging in this case.


  <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