Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2012 @ 16:11:05 GMT


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


Subj:   Using Partition backup for multiple specific
 
From:   Barner, Eric

Hi all,

I am trying to figure out if there is a way through a single arc script, to build a job which can back up several non-contiguous specific partitions in one command / single data file etc... with ARC.

The below is an example of backing up a single partition from a table.

     /*Single Partition Backup*/
     ARCHIVE DATA TABLES
     (myDB.myTable)
     (
     PARTITIONS WHERE
     (! Start_Date BETWEEN '2011-02-14' AND '2011-02-21'!), ), RELEASE LOCK, FILE=ARCSP;

Is there a way to do something like the below?

I want to selectively backup partitions with non-contiguous ranges in one pass.

     /*Multi partitions Backup (syntax not correct)*/

     ARCHIVE DATA TABLES
     (myDB.myTable)
     (
     PARTITIONS WHERE
     (! Start_Date BETWEEN '2011-02-14' AND '2011-02-21'!), (!Start_Date BETWEEN  '2012-03-07'
     AND '2012-03-14'!) ), RELEASE LOCK, FILE=ARCMP;

What I don't want to do is generate a separate ARC scripts for every partition (or minimally the contiguous partition ranges) as it adds a high degree of clutter for managing backups when many partitions need to be backed up.

I also don't want to have to use a partition range like Date BETWEEN '2011-02-14' AND '2012-03-14' to cover the full range of the min and max partitions , as that defeats the purpose of trying to optimize the backups to only the partitions where data has changed.

The syntax guide and ARC documentation doesn't really indicate that there is way , but doesn't say that you can't.

Is there a way (ARC syntax construct) to do this?


Regards,

Eric W. Barner



     
  <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: 27 Dec 2016