Archives of the TeradataForum

Message Posted: Tue, 20 Mar 2007 @ 15:29:38 GMT


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

Subj:		Re: Scan the whole tape to restore the small table

From:		fachtna.c.donovan

Hi Amol,

The simple answer is yes it will have to scan the entire tape and the only way to speed it up is to but faster tape readers!

If you are using a regular ArcMail archive Teradata will archive the Databases and the tables within these databases in alphabetical order.

ie if you have two tables you want to restore from the same database Account_Detail & Transaction_Detail your restore would have to read all tables from the very start of the file (ie all the 'A', 'B', 'C'...) until it got to the end of the Transaction Table to restore back these two tables.

There are other tools/applications for Archiving from Teradata eg NetVault. When NetVault archives a tables for Teradata it also stores an index/position on the archived tape so that a restore can jump directly to the table required once this indexing is turned. I'm not aware on any native settings in ArcMain for doing this.

Hope this helps,

Fachtna O'Donovan
Software Engineer
AIB Bank
Ireland