Setting the frequency of the Collect process

By default, FF COLLECT, FP COLLECT, and ENDOFDAY functions are scheduled to execute daily. The Data Collection Interval default is 28 days. The FF COLLECT HOURLY function can be scheduled at intervals that are smaller than one day.

You can customize schedules or related parameters as necessary. For example, you might want to decrease the frequency of a COLLECT function or increase the Data Collection Interval for a database group that you know experiences little processing.

COLLECT functions are also initiated by the following events:

• You can issue a request to execute FF COLLECT and FP COLLECT functions on demand.
• COLLECT functions might be executed automatically, based on information that was gathered during end-of-day processing (ENDOFDAY function). For example, if end-of-day processing determines that base values must be updated, COLLECT functions are executed to collect the data.
• COLLECT functions are executed automatically when any of the following BMC products, utilities, and functions are executed:
  • MAXM Reorg/Online for IMS
  • MAXM Reorg/EP for IMS
  • MAXM Reorg/EP for IMS with Online/Defrag Feature
  • MAXM Reorg/EP Express for IMS
  • UNLOAD PLUS/EP for IMS
  • LOADPLUS/EP for IMS
  • SECONDARY INDEX UTILITY/EP
  • FAST REORG FACILITY/EP
  • CHANGE RECORDING FACILITY
  • POINTER CHECKER PLUS®
  • BMC Fast Path/EP Analyzer (standalone or under other Fast Path functions)
• When a database is reloaded by using the IBM reorganization utility, Database Advisor recognizes that event and executes immediate data collection or schedules data collection for the end of the day, depending on user-controlled parameters.