Archives of the TeradataForum

Message Posted: Thu, 05 May 2005 @ 12:23:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

PackDisk can be run when ther cylinder has very low space remained for the insert or update activity

No packdisk is not an automated 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 is 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 has been freed by PACKDISK. If you feel that PACKDISK reports a very different number of cylinders freed than SHOWFSP, then do a defrag.

	<Prev	Next>		<<First	<Prev	Next>	Last>>