Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 03 May 2002 @ 18:39:37 GMT


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


Subj:   Packdisk maintenance job
 
From:   Hakim Chambaz

Hi all,

We are planning to schedule a "Packdisk " job maintenance on our Teradata system (V2R4.0.1), and we are looking for an appropriate Free Space Percent (FSP) . Our main tables were created with an FSP = 0 (according to DBSControl Parameters) . Also, these tables are loaded by MLOAD every week, and the space increase represents 0.8 %. We expect tables expansion (almost no records erasing) as our tables are almost read-only, and we want to avoid cylindres split (we `ve got a 'Minicylpack' recently). We believe an approppriate not null value of FSP can help us for a Teradata performance optimisation.

However, recommandations on NCR documentation "Teradata for UNIX Performance Optimisation" seems to be a little bit confused for us in choosing an appropriate FSP value.

Any issues, ideas or suggestions are welcome. Thanks in advance.

Hakim Chambaz
Service Technologie - Environnement Informationnel



     
  <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: 27 Dec 2016