Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2000 @ 19:22:06 GMT


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


Subj:   Teradata Mgr Space Usage Rpts
 
From:   Yvonne Dishon

Hello All,

In the space usage report (Hierarchy) in Teradata Manager the Hierarchy Space reflects the max spool for DBC where it displays max perm for all underlying DB's. It also picks up the 'In Use' total which turns out to be sum of the currentperm for each database in DBC.Tablesize. The 'In Use' figure for DBC does not appear to correlate to anything I can find. Can anyone explain what the 'In Use' total for DBC truly reflects?

Here are the numbers from the Space Usage Report

     HierarchySpace(MaxSpool)                In Use
              133,946,230,702         7,894,576,640

     From DBC.AllSpace
     sum(currentPerm)        sum(PeakPerm)           sum(PeakSpool)
        3,043,604,480        3,621,446,144              528,211,456

     sum(MaxPerm)
     24,439,080,702

     From DBC.TableSize
     sum(currentPerm)
     1,521,805,824

Thank you,

Yvonne Dishon
Database Analyst III
University of Cincinnati



     
  <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: 27 Dec 2016