Using the optdiag Utility to Assess the Need for a reorg

To assess the need for running reorg, 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 Performance and Tuning Series: Physical Database Tuning > Statistics Tables and Displaying Statistics with optdiag. For information about optdiag, see the Utility Guide.