How to collect statistics

You can control the automatic collecting of statistics by scheduling the ARSMAINT program to run with the appropriate options.

You can also manually collect statistics by running the ARSMAINT program from the prompt. For example, to collect statistics on all tables in the database that have changed since the last time that statistics were collected:

     arsmaint -r

When the ARSMAINT program collects statistics on a table, it saves the following message in the system log:

     164 ApplGrp Segment Maintenance (ApplGrp) (Segment)

One message is saved in the system log for each table on which statistics were collected.