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

Automatic Runstats

P: n/a
Hi.
I am trying to test out the automatic maintanance with notification
feature of DB2 v8.2. I have enabled the auto maint with notification.
The problem I am facing is that I only get email notifications from DB2
when there is an alarm as follows:

ADM10500E Health indicator "Monitor Heap Utilization"
("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %"
with value "124 %" on "instance" "DB2"....

I dont get any email notification from DB2 after an automatic runstats
has been run. I know that DB2 has run runstats because I can see it in
the db2diag.log but I dont receive an email. Should I be receiving an
email notification for this?

Thanks a lot in advance !!

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ra***@yahoo.co.uk wrote:
Hi.
I am trying to test out the automatic maintanance with notification
feature of DB2 v8.2. I have enabled the auto maint with notification.
The problem I am facing is that I only get email notifications from DB2 when there is an alarm as follows:

ADM10500E Health indicator "Monitor Heap Utilization"
("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %"
with value "124 %" on "instance" "DB2"....

I dont get any email notification from DB2 after an automatic runstats has been run. I know that DB2 has run runstats because I can see it in the db2diag.log but I dont receive an email. Should I be receiving an
email notification for this? It matters what are the db cfg parameters set to. If AUTO_MAINT,
AUTO_TBL_MAINT and AUTO_RUNSTATS are ON, then DB2 runs RUNSTATS and you
will receive email notifications only if for some reason DB2 was not
able to complete RUNSTATS successfully.

If the db cfg parameters are OFF (at least one of them is OFF), then
DB2 is not running RUNSTATS, but it still checks whether the tables
need RUNSTATS and it sets the Health Indicator (HI) accordingly. The HI
is at database level, so you are supposed to receive a single email
when it goes into alert state.

Because of a bug, DB2 does not send email notifications for Automatic
Table Maintenance (AutoRunstats and AutoReorg) in 8.2. It will be fixed
in an upcoming fixpak.

Regards,
Ivan

Thanks a lot in advance !!


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.