471,830 Members | 1,637 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,830 software developers and data experts.

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 3655
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
NeoPa
reply views Thread by NeoPa | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.