Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2003 @ 07:22:06 GMT


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


Subj:   Re: Scheduling a Packdisk maintenance job
 
From:   Dennis Calkins

Sorry I should explain my terminology.

Free Space Percent (FSP) is the amount of the cylinder that is FREE

Cylinder Fill Factor (CFF) is the amount of the cylinder that is IN USE.


They represent inverse values each other.

FSP + CFF == 100% of the cylinder space.

They can be used interchangably depedning on whether you think of the cylinders as 20% free (FSP) or 80% full (CFF) provided the Abbreviations are provided.

You can set a Table level Attibute called FREE SPACE PERCENT.

alter table blort, FREESPACE = x PERCENT;

that automatically leaves x% free space on the cylinder available for future growth of this table when the table is loaded via multiload or Fastload. That space is then used when you insert, update or delete rows

one at a time
via insert/select
via Merge Into
via TPUMP



     
  <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