How to archive in ARCmain.

Tools
Teradata Employee

How to archive in ARCmain.

Hi,

I am new to arcmain. i have witten a simple archive arcmain script but now i have following requirement while archiving a teradata database:

·         How to archive file to particular location (e.g C:\user\backup)

·         How to divide archive file into chunks (like 100mb per file)

·         How to apply compression on archive file

Following is my simple arcmain script:

arcmain SESSIONS=8 OUTLOG=ARCALL.OUT

logon ip/db,pswd;

ARCHIVE DATA TABLE (db.table),(db.table2), RELEASE LOCK, FILE= ARCHIVE;

logoff;

Thanks in advance

Tags (1)
5 REPLIES
Teradata Employee

Re: How to archive in ARCmain.

On the command line you can map the "internal" filename to an "external" name:

arcmain SESSIONS=8 OUTLOG=ARCALL.OUT FILEDEF=(ARCHIVE,C:\user\backup)

ARC itself does not support splitting or compressing the output file.

Teradata Employee

Re: How to archive in ARCmain.

Thanks a lot Fred :)

Re: How to archive in ARCmain.

Is there is anyway to decode the ARCmain file? 

Re: How to archive in ARCmain.

That syntax is not working for me.

    arcmain FILEDEF=(ARCHIVE,C:\user\backup)

results in the following error:

   bash: syntax error near unexpected token `('

Re: How to archive in ARCmain.

Never mind, I found that on Linux the FILEDEF requires single quotes:

   arcmain FILEDEF='(ARCHIVE,C:\user\backup)'