17.00 - 17.05 - About Finding Loosely Packed Tables with the SHOWFSP Command - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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 .