Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023