16.10 - About Finding Loosely Packed Tables with the SHOWFSP Command - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Use the SHOWFSP command of the Ferret utility before running PACKDISK to estimate the effectiveness of PACKDISK commands. SHOWFSP helps you find loosely packed tables.

The SHOWFSP command gives an approximation of the number of cylinders that can be freed by PACKDISK. It may or may not match with the exact number of cylinders that will be freed. If you feel that PACKDISK reports a very different number of cylinders freed than SHOWFSP, then perform a defrag with the DEFRAG command.

==========================================================          
Ferret  ==>
showfsp
Fri Jun 06, 2003  12:06:02 : showfsp will be started on All AMP vprocs
Fri Jun 06, 2003  12:06:02 : to find all the tables specified greater than 0 cylinders
Fri Jun 06, 2003  12:06:02 : which could free up more than 0 cylinders
Fri Jun 06, 2003  12:06:02 : only tables with a current FSP greater than  0%
Fri Jun 06, 2003  12:06:02 : will be considered
    Do you wish to continue based upon this scope?? (Y/N)
y
Fri Jun 06, 2003  12:06:04 : ShowFsp has been started
                             On All AMP vprocs
vproc  0 (0000)  response
There are  6 tables larger than 0 cylinders on amp 0

Database           Table                   fsp    Recoverable  Current
Name               Name                    %      Cylinders    Cylinders
-----------------  ----------------------  -----  ----------   ---------
CUSTOMER           ppitable3                 25   1            5
vproc  1 (0001)  response

There are  6 tables larger than 0 cylinders on amp 1

Database           Table                   fsp    Recoverable  Current
Name               Name                    %      Cylinders    Cylinders
-----------------  ----------------------  -----  -----------  ---------
CUSTOMER           ppitable4               34     1            5
2 of 2 vprocs responded with the above tables fitting the criteria
ShowFsp has completed
 

For information on the settings and options for SHOWFSP, see “Ferret Utility (ferret)” in Utilities.