Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2008 @ 23:28:33 GMT


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


Subj:   Re: Creating a table with a 0 skew factor
 
From:   Diehl, Robert

I would suggest that you don't create tables to reserve space. This just fills up the disk. You want to have open cylinders on your machine so the system does not perform tasks like mini cylinder packs which can really slow down performance.

I would suggest doing one of two things.

1) create a capacity on demand database. Allocate it with the space you want to reserve.

2) put the space in DBC. Move it when you need to use it. This has the advantage of preventing problems when DBC gets full or even goes negative from large Transient Journals. Disadvatge is you have to keep track of how much extra space you have left to allocate.


Thanks,

Bob Diehl



     
  <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