Automatic Runstats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

raqfg@yahoo.co.uk - 24 Feb 2005 10:14 GMT

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 !!

Reply to this Message

Ivan Popivanov - 25 Feb 2005 21:37 GMT

> Hi.
> I am trying to test out the automatic maintanance with notification
[quoted text clipped - 10 lines]
> 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 !!

Reply to this Message