Archives of the TeradataForum

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

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

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>>