Saturday, January 5, 2013

Online Archiving in Teradata


Online archiving feature of the arcmain utility allows backing up data online in teradata without recording a Permanent Journal. instead it internally create log for object that is being archived and any changes on the tables are captured. it permits you to archive tables or entire databases
while applications are actively updating the tables that are being archived.

You can enable online archiving for pertculer database or table by using below command in arcmain prompt.

LOGGING ONLINE ARCHIVE ON FOR (DATABASENAME.TABLENAME);

Or

you can specify ALL keyword to enable all tables in a database.


LOGGING ONLINE ARCHIVE ON FOR (DATABASENAME) ALL;


Once Online archiving is enabled, it can be confirmed by querying database, for Ex.

select CreateTimeStamp,
DatabaseName (VARCHAR(30)),
TVMName (VARCHAR(30))
from DBC.ArchiveLoggingObjsV;

          
 Finally Online archiving can be disabled by command.

LOGGING ONLINE ARCHIVE OFF FOR (DATABASENAME) ALL;



No comments:

Post a Comment