Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Sep 2012 @ 23:38:15 GMT

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

Subj:   Re: Rolforward to checkpoint from a Journal
From:   Anomy Anom

< -- Anonymously Posted: Friday, September 21, 2012 17:29 -- >

Then ROLLFORWARD will stop at the first CHKMON it finds in the restored journal, even if that was from weeks ago, unless you use the event ID reported by the Checkpoint command.

When you use permanent journals, you are responsible not only for checkpointing "active" to "saved" subtable so you can archive, but also explicitly deleting "saved" records from the journal when appropriate. ROLLFORWARD / ROLLBACK by default delete the "restored" subtable, but ARCHIVE JOURNAL never deletes the "saved" subtable. Note that DELETE JOURNAL purges the entire subtable, there is no way to filter selected records.

While you could opt to purge journal records every time you archive the journal, you typically will want to accumulate checkpoints in "saved" until your next full backup. For example, a weekly job might: archive the table but retain the lock, checkpoint with save and archive the journal, delete the saved journal, then release the lock on the table.

  <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