Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 16 Mar 2006 @ 22:36:00 GMT


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


Subj:   Re: Identifying Large NUSI ?
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, March 16, 2006 17:15 -->

"It will not give NUSI size ... only identifies size of tables that have NUSI's"

Yes Lisa, that's correct.

Because the currentperm information in DBC is always kept as only the sum of the space utilized in each AMP by all subtables belonging to the table, this is due to the fact that in order to keep track of space utilization, Teradata uses only the first 32 bits from Table ID in table DBC.DatabaseSpace (as type BYTE(4)), not considering the additional 16 bits from Table ID, which identify each specific subtable.

As others have stated, you must use ferret to know how much space belongs to each subtable.



     
  <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