In DB2 version 10 you can define statistics profiles for each table. The
profile is stored in SYSIBM.SYSTABLES_PROFILES and describes the
different RUNSTATS options that should be used for each table. The
RUNSTATS utility USE PROFILE option allows you to execute RUNSTATS for
multiple tables when each table uses different defined options.
TUC allows to define the RUNSTATS profile for each table. The dialog
allows you to edit the different RUNSTATS options, such as COLGROUP, in
an edit session. This functionality is also available prior to DB2
version 10 since TUC preserves the RUNSTATS profile also in the TUC
control database. Since the USE PROFILE option is not available prior to
version 10, the RUNSTATS statements can be prepared for each table with
the defined statistics options. Once you migrate to DB2 version 10, the
options you have defined for each table will be automatically propagated
into the DB2 catalog to allow you to immediately take advantage of the
new DB2 version 10 feature.