Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Aug 2002 @ 19:18:36 GMT

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

Subj:   Re: Rollback on long-running update
From:   Anomy Anom

<-- Anonymously Posted: Thursday, August 01, 2002 14:35 -->

  Does any one have any experience on how to handle this? Are there any options available where one can reduce the loss of service during a rollback?  

  Start dbscontrol and look at general field 10, RollbackPriority.  

You can also use Performance Monitor to modify the account string, and therefore the priority, of the session performing the rollback. With PSF, you can concoct even subtler potions.

  Basically there is not a lot you can do with rollback... short of let roll baby roll... all night long...!  

Yes, but it still may be preferable to the alternative. Recently we allowed a large update to continue rather than abort it and let it roll back. It took six days to finish!

  <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: 28 Jun 2020