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.