Using the optdiag utility to assess the need for a reorg

To assess the need for running a reorg, you can use statistics from the systabstats table and the optdiag utility. systabstats contains statistics on the utilization of table space, while optdiag generates reports based on statistics in both systabstats and the sysstatistics table.

For information on the systabstats table, see the Performance and Tuning Guide. For information about optdiag, see Utility Programs for UNIX Platforms.