Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  

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


     From DBC.TableSize

Thank you,

Yvonne Dishon
Database Analyst III
University of Cincinnati

  <Prev Next>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023