Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 05 Oct 2012 @ 12:24:56 GMT

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

Subj:   Re: Compression Process on Teradata 13.10
From:   Dieter Noeth


  Personally I think it doesn't matter if it's ARCMAIN on MF or not, the tool remains the same. (Please esteemed experts don't shoot me if I'm wrong). I think internally it must be some kind of flag. ARCmain seems to notice whether or not data is compressed or not. If data is compressed at the time of the backup, it gets restored compressed, if not it'll get restored as before, regardless whether the auto compression parameters are on or not.  

Hi Raf,

did you try to switch on compression in your restore script using querybanding adding SET QUERY_BAND 'BLOCKCOMPRESSION=YES;';

I just tested it and my table was compressed during restore :-)

Caution, in the 13.10 manuals there's a bug: Instead of 'BLOCKCOMPRESSION=Y' it's 'BLOCKCOMPRESSION=YES'


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