Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 28 Jan 2014 @ 21:38:37 GMT


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


Subj:   Re: BACKUP Session blocking in ONLINE MODE
 
From:   Martin Barrow

Hi Sravan,

For the online logging to start it needs to take a checkpoint - so hence it needs to lock the table. Generally you will stop batch to take the checkpoint. From a RPO objective it also makes sense to stop the batch, otherwise how do you know what at which point you are restoring your data to?

The objects are available for read during the checkpoint capture.


Regards,

Martin Barrow
Lead DBA, PHI IT - EDWBI BAU Support



     
  <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