Db2 Automation Expert can use different sources of statistics to determine if the objects that are specified in the object profile meet exception criteria. You can choose the source from the Edit Exceptions Profile Options window.
About this task
Refer to Specifics about exception conditions for more information about how statistics are used in evaluating exception conditions.
Procedure
- On the Update Exceptions Profile Display, ensure that the Update Exception Profile Options field is displayed.
If it is not, enter the OPTIONS command and select the Show update profile options field.
- On the Update Exceptions Profile Display, enter Y in the Update Exception Profile Options field and press Enter.
- On the Edit Exception Profile Options window, specify one of the following in the Use Stats From field:
- Enter R to use the Db2 Automation Expert repository of statistics.
- Enter C to use Db2 catalog statistics.
- Enter S to use a Db2 shadow catalog. To use this option, you must have added the shadow catalog package list name to the Shared Profile Parameters configuration panel.
- Enter H to use Db2 history statistics from the _HIST tables.
- Enter U to have Db2 Automation Expert invoke a RUNSTATS utility. The statistics generated by RUNSTATs are used in evaluating the exception conditions. You should also specify RUNSTATS options by entering Y in the Edit Runstats Options field.
-
Press Enter.