Finding Loosely Packed Tables with the SHOWFSP Command - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

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 execute 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 Teradata Vantage™ - Database Utilities, B035-1102.