Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 14 Feb 2004 @ 20:10:22 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Table Block Size
From:   Dennis Calkins

Run the showblocks command from the Ferret utility via the DBW

from the supervisor screen type

start ferret

This will start the ferret utility in one of the application windows.

in the ferret window type

scope table ( "mydatabse.mytable" 0 )

The Quotes are required but can be single or double as long as they match.

then you execute the showblocks command.

showblocks /s -- show summary of only the primary Data Table

showblocks /m -- show summary of all the subtables.

showblocks /l -- show the actual db counts and MIN,MAX,Avg # of rows.

remember to QUIT ferret when you are done.

  <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