Archives of the TeradataForum

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

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

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>>