niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » IBM DB2
Automatic Runstats
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Ivan Popivanov
*nix forums beginner


Joined: 13 Jun 2005
Posts: 7

PostPosted: Fri Feb 25, 2005 8:40 pm    Post subject: Re: Automatic Runstats Reply with quote
raqfg@yahoo.co.uk wrote:
Quote:
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

Quote:

Thanks a lot in advance !!
Back to top
raqfg@yahoo.co.uk
*nix forums beginner


Joined: 24 Feb 2005
Posts: 1

PostPosted: Thu Feb 24, 2005 9:14 am    Post subject: Automatic Runstats Reply with quote
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 !!
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 3:50 am | All times are GMT
navigation Forum index » Databases » IBM DB2
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Automatic /var/spool/mail cleaning Cédric MARCOUX Exim 5 Thu Jul 20, 2006 8:31 am
No new posts 7044-170 automatic boot after power on temp_acc@yahoo.de AIX 5 Tue Jul 18, 2006 7:27 pm
No new posts automatic moving files in to folders dave shell 1 Thu Jul 13, 2006 9:39 pm
No new posts automatic timestamp Nestor MySQL 4 Thu Jul 06, 2006 12:26 am
No new posts Automatic Installer Joko Siswanto PostgreSQL 1 Mon Jul 03, 2006 6:27 pm

Loans | Car Loan | Bankruptcy | Credit Counseling | Jordan 4
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2303s ][ Queries: 20 (0.1627s) ][ GZIP on - Debug on ]