Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Dec 2007 @ 15:30:09 GMT


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


Subj:   Re: Data BlockSize
 
From:   Anomy Anom

<-- Anonymously Posted: Fri, 14 Dec 2007 08:05 -->

Ferret PACKDISK is concerned with number of "free sectors" within a "logical cylinder", and only moves existing blocks between cylinders. (And if an entire cylinder becomes free sectors, that cylinder is returned to the free list.)

Ferret DEFRAG is concerned with location of "free sectors" within a "logical cylinder", and only moves existing blocks within a cylinder to make free sectors as logically contiguous as possible.

If you want to actually "reblock", i.e. change the size of existing blocks, you use ALTER TABLE DATABLOCKSIZE IMMEDIATE.

Under MP-RAS, you can script ferret via the cnsrun command. It's not in the PDF manuals, but a "man page" is installed with PDE.



     
  <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