Archives of the TeradataForum
Message Posted: Sat, 14 Feb 2004 @ 20:10:22 GMT
Run the showblocks command from the Ferret utility via the DBW
from the supervisor screen type
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|