Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: How to know the size of storage space of NUSI???
From:   Dennis Calkins

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020