 |
 |
Archives of the TeradataForum
Message Posted: Fri, 05 Oct 2012 @ 12:24:56 GMT
| Subj: | | Re: Compression Process on Teradata 13.10 |
| |
| From: | | Dieter Noeth |
Raf VANDORMAEL wrote:
| | 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'
Dieter
| |
