Automatic RUNSTATS in 8.2

[Gilda]

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.

[Martin Neumann]

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_LIM IT 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.

[Gilda]

Thank you for your feedback. A more basic question-it looks like the
automatic maintenance checks only happen when Control Center is up.
Is that correct? Is that when the Health Monitor is started?

Gilda
Martin Neumann <nn************ ***@spamgourmet .com> wrote in message news:<ck******* ***@online.de>. ..

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_LIM IT 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.

[Sean McKeough]

With 8.2 hmon always starts...it's now an engine edu (you can see it if
you're on UNIX).

Gilda wrote:

Thank you for your feedback. A more basic question-it looks like the
automatic maintenance checks only happen when Control Center is up.
Is that correct? Is that when the Health Monitor is started?

Gilda
Martin Neumann <nn************ ***@spamgourmet .com> wrote in message news:<ck******* ***@online.de>. ..

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_LIM IT 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
collection s are required, if the Automatic RUNSTATS is enabled, in
version 8.2?
How often are these checks done?

Thanks.