Archives of the TeradataForum

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

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

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>>