Finding Loosely Packed Tables with the SHOWFSP Command
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.