Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 19 Apr 2007 @ 18:56:26 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Compression of Archive Files
From:   william.gregg

Bill - I found the same thing. The archive space savings are found when an archived table has secondary indices. Generally the DBA does not archive the sub-table (SI) contents. When the SI data is ignored, the amount of data archived shows as a number smaller than the currentperm for the table. Often the archive storage system will compress the data when (eg. TSM) options are set to do that, but that is not part of the ARCMAIN processing.

A word to the wise: those secondary indices make their presence felt when recoveries are required.

Bill Gregg
Teradata Team
Thomson Healthcare

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020