Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 13:34:39 GMT


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


Subj:   Re: Why are _ET,_UV,_LOG created as Fallback?
 
From:   Adam DeYoung

If you were to have a storage drive fail while your MLOAD was in progress and the error/log tables were non-Fallback, the MLOAD could not complete successfully and your target table would be in an incomplete state until the failed drive was rebuilt and the MLOAD completed. Because incomplete MLOADs leave you exposed to target table corruption and prevent other processes from writing to that table, it is wise to do all you can to avoid this state.

With Fallback on both the log/error tables and the target table, the MLOAD keeps running with no issues when a drive fails.

Adam



     
  <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