Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 01 Jan 2002 @ 13:16:11 GMT


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


Subj:   Re: Raw data size
 
From:   Dennis Calkins

Hi,

you could use Ferret

    output over /tmp/ferret.out
    SHOWBLOCKS /m
    quit

to get the individual table sizes

    1024   Primary data table
    1028, 1032, ...   Indexes

    2048,  Fallback primary data table
    2052, 2056, ...    indexes

    3072,  Fallback primary data table
    3076, 3080, ....   indexes

Then you could take the output and run it through an AWK or PERL script and add up the individual table sizes. (multiply the AVG datablock size * number of Datablocks / 2 == # K for that table )

this will give you the amount of Perm table space (including Fallback) in Kilobytes

   egrep "      1024|      2048|     3072|     4096" /tmp/ferret.out | \
      awk 'BEGIN {FS="|"} ;{tot += ($14 * $16 / 2)} END {print tot}'

you can do the same for the index subtables, 1028, 1032,....

I think the $14 and $16 are correct. it might be 13 and 15 or 15 and 17 depending on your release.

Now depending on your release SHOWBLOCKS has some issues being run on a active system. They are all fixed in 4.1.



     
  <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