Archives of the TeradataForum

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

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

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?).

Regards

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