Monitoring reservepagegap settings

You can use optdiag to check the cluster ratio and the number of forwarded rows in tables. Declines in cluster ratios can also indicate that running reorg commands could improve performance:

To reduce the frequency with which you run reorg commands to maintain cluster ratios, increase the reservepagegap slightly before running reorg rebuild.

See Chapter 37, “Statistics Tables and Displaying Statistics with optdiag,” for more information on optdiag.