Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2006 @ 23:08:26 GMT


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


Subj:   Re: Automating Space management
 
From:   Frank.C.Martinez

We have a system of stored procedures that add space before a production load to a database and then takes it back after the work is done. We're just putting the auto add and subtract space functionality into production. So we dynamically add the necessary space, return the unused space, and then change the allocation if there's an normal increase. There is also a verify step that checks to see if there's something unusual happening, like if the number of records coming in (for full refreshes) is less than the records that were out there before. It's not integrated, not every process uses it, but it works enough that we like it. It was originally written by one of our dba's who's since passed to the great beyond (well, ok, he went to work for NCR).


iv


PS: Are you out there listening, Andrew?



     
  <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