The RUNSTATS is triggered by the Health Monitor based on data collected
by the DB2 Engine. DB2 decides when to do RUNSTATS based on the workload
of your DB2, you do not know in advance how often and when these checks
are done. You can check the db2diag.log if you want to know how often
the checks are done in your setup.
You can use the DBM CFG parameter UTIL_IMPACT_LIMIT to set an upper
limit to the impact on your system and you can specify a maintenance
window if you do not want RUNSTATS to run during certain times.
Regards,
Martin Neumann
Marvin Consult
Gilda wrote:
Does anyone know what entity (utility?) checks if statistics
collections are required, if the Automatic RUNSTATS is enabled, in
version 8.2?
How often are these checks done?
Thanks.