By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Automatic RUNSTATS in 8.2

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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_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.

Nov 12 '05 #3

P: n/a
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_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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.