Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 17 Mar 2005 @ 13:49:06 GMT


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


Subj:   Re: Questions abt Permanent Journal
 
From:   Pynegar, Sheila

Hi

Permanent jounals are not deleted automatically.

When you issue a checkpoint with save the saved journal can be deleted or archived.

There are 2 options after journal and before journal.

If a table is archived say on a Monday, after image jornals can be archived nightly. This requires less time for the archive process.

If a table needs to be restored (on a Thursday) it would be restored from the Monday dump, then one would restore Tuesdays journal roll forward with that and then the same for Wednesday. The current jounal (Thursday) is then used to roll forward.


Hope this helps

Regards Sheila
Sheila Pynegar
Certified Teradata Master



     
  <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