Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 25 Oct 2010 @ 18:02:30 GMT


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


Subj:   Re: Defragmentation
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, October 25, 2010 13:43 -->

Hi Rishi,

I forwarded your question to one of the Teradata Developers. Below is his response to your question.

Setting the DefragLowCylProd value higher will cause defrag to run more often. The max value you can set it to is 65535 (cylinders).

When using FERRET you really would want to use the DEFRAGMENT command not the PACKDISK command. Packdisk might cause some cylinders to get defragmented but only as a side effect. DEFRAGMENT will do a more thorough job - especially when the FORCE option is used. Without FORCE, the DEFRAGMENT command will not process cylinders unless 25% of the sectors on the cylinder are considered fragments (too small for DB allocations to succeed.

Hope this information helps!


Thanks.



     
  <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: 15 Jun 2023