Archives of the TeradataForum

Message Posted: Wed, 23 Mar 2005 @ 06:24:03 GMT

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

Since this appears to be cross posted from www.teradata.com I will respond here as well.

Showblocks from Ferret and a little math.

start ferret from the supervisor window of DBW.

in the ferret window type

     scope table "mydatabase.mytable" 0

The Quotes are required. Single / double doesn't matter as long as they match. Substitute your own database and table name.

then type

     showblocks /m

It is a Very WIDE display.

The 0 table are the collective table headers from all the amps.

the 1024 table is the primary data table.

1028 , 1032, 1036 .... are the Secondary index tables. They should correspond to the order of the indexes displayed from Show table.

the 2048, 3072, 4096 ... tables are the Fall back copies of the Primary data table.

the 2052, 2056, 3076, 3080 .... tables are the fall back copies of the Secondary indexes.

find the line that corresponds to your index.

Column 19 of the display is the Average Datablock size. ( in 1/2 k sectors )

Column 21 is the number of Datablocks.

Multiply the two numbers. You will have the size of your index in sectors.

Divide that by 2 to get Kilobytes

Divide that by 1024 to get Megabytes

Divide that by 1024 to get Gigabytes

Divide that by 1024 to get Terabytes.

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