Collect interval parameters
The following table lists parameters in the Collect Interval category.
Database Advisor uses these parameters for the Collect process.
Parameter | Accepted values | Default value | Description |
|---|---|---|---|
Data Collection Interval | 0 to 365 | 45 | Specify the frequency (in days) to collect statistics for the selected object. The frequency interval is checked by the FF COLLECT function or the FP COLLECT function to determine whether statistics should be gathered so that every database, partition, or area object would not be processed each time. If the difference between the last day that statistics were gathered and the current day is less than the specified interval, the object is skipped. This parameter is active only if the FF COLLECT function or the FP COLLECT function is scheduled to run automatically. If you do not want to collect data for the selected object, specify zero. To use the inherited value, clear the current value. |
Activate Fast Path Space Data Collection | Inherit Yes No | No | Specify whether the FP SPACE COLLECT function should run at the scheduled interval (in hours) to gather IOVF and SDEP statistics for a Fast Path area data set. This parameter is active only if the FP SPACE COLLECT function is scheduled to run automatically. |
Activate FF Hourly Collect | Inherit Yes No | No | Specify whether the FF COLLECT HOURLY function should run at the scheduled interval (in hours) to gather statistics for full-function databases and HALDBs. This parameter is active when the FF COLLECT HOURLY function is scheduled to run automatically. |
Related topic