Archives of the TeradataForum

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

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

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