469,306 Members | 1,881 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,306 developers. It's quick & easy.

Automatic RUNSTATS in 8.2

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
3 3564
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
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
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.

Similar topics

7 posts views Thread by Todd McNeill | last post: by
1 post views Thread by raqfg | last post: by
6 posts views Thread by Gert van der Kooij | last post: by
4 posts views Thread by db2group88 | last post: by
4 posts views Thread by kenfar | last post: by
1 post views Thread by Michel Esber | last post: by
3 posts views Thread by Norm | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.