Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Oct 2004 @ 07:37:18 GMT


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


Subj:   Re: DBC Space Requirement
 
From:   David Wellman

Hi,

Glenn is almost certainly correct in that this problem is caused by skewed data.

However, database DBC is as prone to skewed data as any other database. The Accessrights table is notorious for being skewed and as it can be quite large this can affect the space limits quite dramatically. To reduce this skewing you have to either clean up Accessrights - removing redundant rows - and/or convert to using Roles - and then remove the now redundant rows.

The other table that can be very skewed is TransientJournal. In this case though the skewing is caused by the work that's running on the system. What it's showing is that one or more queries are doing lots of maintenance on typically a single AMP. You need to track that query down and tackle it like any other skewed processing.


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