Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 13 Sep 2005 @ 17:03:23 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Customizing Arcmain
From:   Diehl, Robert


Simple solution.

1) run script to create ARC script. This script can be bteq, perl or whatever you like. It basically just has to use dbc.tables.CreateTimeStamp

2) execute ARC script create in step 1

I have seen this technique used at several sights. It is usually done to split the tables up into groups so can have several streams running at same time without using cluster backups. It also means you don't have to change scripts when new tables are added to a database where an archive is not taken at the database level.


Bob Diehl

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020