Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2013 @ 16:03:16 GMT

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

Subj:   Re: Difference between ARCMAIN format and Universal format
From:   Leslie, Quincy

ARCMAIN creates an "image" that is not directly readable, as would a delimited flat file would be, i.e. csv, pipes, etc. Advantage of ARCMAIN is that if an image is laid down on a new target server, using the COPY command, then the table is created, if it does not exist (provided the database exists), plus the source DDL is brought over and updates the target table, if it already exists, with the latest DDL. This is the technical approach in TD Unity Data Mover, ARCMAIN extract from source and COPY laydown to the target server. Disadvantage of ARCMAIN is that its archives become "stale", if the archives TD Ver# becomes too far removed from the current server DBMS ver# and the archive ceases to be forward compatible and will not be recognized, aka will not lay down in the current dbms. Usually this is about a 5-9 years aged archives. Varies with how broad the difference is between the current and archive dbms versions (Mr. obvious?).


  <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: 24 Jul 2020