Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2005 @ 15:04:43 GMT


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


Subj:   Re: DBC Space management
 
From:   David Wellman

Hi,

Have a look at which tables are the biggest:

     sel tablename,sum(currentperm)
     from dbc.tablesize
     where databasename = 'dbc'
     group by 1
     order by 2 desc;

You'll probably find the big ones are the resusageXXXX or dbqlXXX tables. These hold (respectively) the resusage data and query log data. Tailor those settings to reduce the amount of space consumed by dbc tables on an ongoing basis.

Also, you should probably look at moving the data from the real dbc tables to a 'history' database.


Cheers,

Dave



     
  <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