All Forums Tools
wa255015 2 posts Joined 10/15
25 Jan 2016
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:
Fred 1096 posts Joined 08/04
25 Jan 2016

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.

wa255015 2 posts Joined 10/15
25 Jan 2016

Thanks a lot Fred :)

kishorea1505 3 posts Joined 03/16
01 Mar 2016

Is there is anyway to decode the ARCmain file? 
 

Kishore~A

08 Mar 2016

That syntax is not working for me.
    arcmain FILEDEF=(ARCHIVE,C:\user\backup)
results in the following error:
   bash: syntax error near unexpected token `('

Doug Michael

08 Mar 2016

Never mind, I found that on Linux the FILEDEF requires single quotes:
   arcmain FILEDEF='(ARCHIVE,C:\user\backup)'

Doug Michael

You must sign in to leave a comment.