Need help on arcmain

Tools
Teradata Employee

Need help on arcmain

Hi All,

I'm trying to copy an archive file zipped using arcmain sent to me and trying to restore it on my own teradata database. I need to view the contents of the archive before I load it with the copy db script. I need the name of the database name inside the archive and cannot restore the archive without it ? Can anyone let me know if there is a way to list the archvie objects (databases, tables, views) before we load the archive on target teradata database?

Thanks n Regards,
Raghu
4 REPLIES
Enthusiast

Re: Need help on arcmain

you can use the ANALYZE command to get that information. you don't have to login to database to do it.

look up the syntax and listing options in the archive and recovery manual.
Teradata Employee

Re: Need help on arcmain

Thanks Joe, but ANALYZE works only tape archives. The archive which I have is a "file" archive of a database on some remote Teradata server. It has been copied from the remote server to my laptop. I tried with analyze * long display file=CAN330 and it keeps giving me all kinds of errors.
Enthusiast

Re: Need help on arcmain

can you try something like this ...

ANALYZE ALL, FILE=putFullFilePathIncludingFileNameHere ;

Re: Need help on arcmain

Is it anyway to read the ARCMAIN file output?

We had an old Arcmain file, wondering if there is any way to read it without teradata?