Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Oct 2012 @ 19:56:20 GMT

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

Subj:   Re: Compression Process on Teradata 13.10
From:   Fenwick, Ruth

I'm assuming you're referring to HARDWARD compression rather than software compression since you're on a 2690. This has very little CPU over- head, since the compression is handled via a Card rather than software. And you want compression on for a 2690. Your compression rate will vary, we saw 8x on tables that had little MVC and 2.5x on tables with a fair amount of MVC. So you should see your table sizes reduce significantly.

That being said, is the following DBSCONTROL setting ON or OFF? It must be on for hardware compression (on the whole system, which is what you want)

     DBS Control Record - Compression Fields:
         1.  BlockLevelCompression     = ON

New tables will compress automatically.

To compress existing tables, you have the following two choices: Recreate tables (time consuming)

Ferret Utility - allows you to compress a various levels - entire system, database level, table level.

  <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