Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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