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

Health Monitor Emails and SQL Functions

P: n/a
I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
functions? DB2 8.1.3.132 WR21324.

Another point about the health monitor - when I get notification messages
all they say is that a particular instance/db has a warning or alarm. I
have to open the health centre to see what the actual warning / alarm is. I
would much prefer if the email had at least a hint as to the nature of ther
warning / alarm.

TIA,
Bruce
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
I think you have to run a utility called db2updv8. You can search on it
(or HEALTH_CONT_HI) here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

I'll pass on your concerns about the e-mail.

Bruce MacDonald wrote:
I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
functions? DB2 8.1.3.132 WR21324.

Another point about the health monitor - when I get notification messages
all they say is that a particular instance/db has a warning or alarm. I
have to open the health centre to see what the actual warning / alarm is. I
would much prefer if the email had at least a hint as to the nature of ther
warning / alarm.

TIA,
Bruce


Nov 12 '05 #2

P: n/a
Blair,

Thanks very much - that's exactly what I was looking for!

Bruce
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
I think you have to run a utility called db2updv8. You can search on it
(or HEALTH_CONT_HI) here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

I'll pass on your concerns about the e-mail.

Bruce MacDonald wrote:
I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
functions? DB2 8.1.3.132 WR21324.

Another point about the health monitor - when I get notification messages all they say is that a particular instance/db has a warning or alarm. I
have to open the health centre to see what the actual warning / alarm is. I would much prefer if the email had at least a hint as to the nature of ther warning / alarm.

TIA,
Bruce

Nov 12 '05 #3

P: n/a
One more thought from the Health team - is it possible you set the
Contact to receive Pages and not e-mail? Pages only have a subject line
in the e-mail indicating that there is an alarm or warning. There is no
more info. This matches with what you are saying. If you set the Contact
to recieve e-mail, then you will get a lot more info on the HI, values,
history, etc.

Bruce MacDonald wrote:
Blair,

Thanks very much - that's exactly what I was looking for!

Bruce
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
I think you have to run a utility called db2updv8. You can search on it
(or HEALTH_CONT_HI) here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

I'll pass on your concerns about the e-mail.

Bruce MacDonald wrote:

I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
functions? DB2 8.1.3.132 WR21324.

Another point about the health monitor - when I get notification
messages
all they say is that a particular instance/db has a warning or alarm. I
have to open the health centre to see what the actual warning / alarm
is. I
would much prefer if the email had at least a hint as to the nature of
ther
warning / alarm.

TIA,
Bruce



Nov 12 '05 #4

P: n/a
And another thought: you can also use the db2 GET RECOMENDATIONS FOR
HEALTH INDICATOR shortname ..." and "db2 GET DESCRIPTION FOR HEALTH
INDICATOR shortname" commands from the command line to get more
information.

Blair Adamache wrote:
One more thought from the Health team - is it possible you set the
Contact to receive Pages and not e-mail? Pages only have a subject line
in the e-mail indicating that there is an alarm or warning. There is no
more info. This matches with what you are saying. If you set the Contact
to recieve e-mail, then you will get a lot more info on the HI, values,
history, etc.

Bruce MacDonald wrote:
Blair,

Thanks very much - that's exactly what I was looking for!

Bruce
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
I think you have to run a utility called db2updv8. You can search on it
(or HEALTH_CONT_HI) here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

I'll pass on your concerns about the e-mail.

Bruce MacDonald wrote:
I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
functions? DB2 8.1.3.132 WR21324.

Another point about the health monitor - when I get notification

messages
all they say is that a particular instance/db has a warning or
alarm. I
have to open the health centre to see what the actual warning / alarm

is. I
would much prefer if the email had at least a hint as to the nature of

ther
warning / alarm.

TIA,
Bruce



Nov 12 '05 #5

P: n/a
Blair,

Thanks for the additional reply. As far as I can see the contacts are
definitely email contacts:

If I open the Health Center and then open Tools->Contacts my contacts are
listed as Type=Contact, Pager=No. If I select Change on a particular
contact I get the "Change Contact" dialog box with the "Address is for a
pager" box unchecked.

FWIW, the SMTP email system which is setup for the health center is a
Microsoft Exchange server, and I use Outlook as the client...

Thanks,
Bruce

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
One more thought from the Health team - is it possible you set the
Contact to receive Pages and not e-mail? Pages only have a subject line
in the e-mail indicating that there is an alarm or warning. There is no
more info. This matches with what you are saying. If you set the Contact
to recieve e-mail, then you will get a lot more info on the HI, values,
history, etc.

Bruce MacDonald wrote:
Blair,

Thanks very much - that's exactly what I was looking for!

Bruce
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
I think you have to run a utility called db2updv8. You can search on it
(or HEALTH_CONT_HI) here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

I'll pass on your concerns about the e-mail.

Bruce MacDonald wrote:
I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
functions? DB2 8.1.3.132 WR21324.

Another point about the health monitor - when I get notification


messages
all they say is that a particular instance/db has a warning or alarm. Ihave to open the health centre to see what the actual warning / alarm


is. I
would much prefer if the email had at least a hint as to the nature of


ther
warning / alarm.

TIA,
Bruce


Nov 12 '05 #6

P: n/a
Can you send me a few copies of the e-mails you are receiving?

Bruce MacDonald wrote:
Blair,

Thanks for the additional reply. As far as I can see the contacts are
definitely email contacts:

If I open the Health Center and then open Tools->Contacts my contacts are
listed as Type=Contact, Pager=No. If I select Change on a particular
contact I get the "Change Contact" dialog box with the "Address is for a
pager" box unchecked.

FWIW, the SMTP email system which is setup for the health center is a
Microsoft Exchange server, and I use Outlook as the client...

Thanks,
Bruce

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
One more thought from the Health team - is it possible you set the
Contact to receive Pages and not e-mail? Pages only have a subject line
in the e-mail indicating that there is an alarm or warning. There is no
more info. This matches with what you are saying. If you set the Contact
to recieve e-mail, then you will get a lot more info on the HI, values,
history, etc.

Bruce MacDonald wrote:

Blair,

Thanks very much - that's exactly what I was looking for!

Bruce
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
I think you have to run a utility called db2updv8. You can search on it
(or HEALTH_CONT_HI) here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

I'll pass on your concerns about the e-mail.

Bruce MacDonald wrote:

>I am unable to see the health monitor SQL table functions (e.g.:
>SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
>functions? DB2 8.1.3.132 WR21324.
>
>Another point about the health monitor - when I get notification

messages
>all they say is that a particular instance/db has a warning or alarm.
I
have to open the health centre to see what the actual warning / alarm

is. I
>would much prefer if the email had at least a hint as to the nature of

ther
>warning / alarm.
>
>TIA,
>Bruce
>
>



Nov 12 '05 #7

P: n/a
Further, can you:

1. Open the message.
2. Select File | Properties from the menu.
3. Click on the details tab.
4. Click on the message source button.
5. Copy and paste the contents of the message source window into a note
to me (ad******@ca.ibm.com)? thanks,
Blair Adamache wrote:
Can you send me a few copies of the e-mails you are receiving?

Bruce MacDonald wrote:
Blair,

Thanks for the additional reply. As far as I can see the contacts are
definitely email contacts:

If I open the Health Center and then open Tools->Contacts my contacts are
listed as Type=Contact, Pager=No. If I select Change on a particular
contact I get the "Change Contact" dialog box with the "Address is for a
pager" box unchecked.

FWIW, the SMTP email system which is setup for the health center is a
Microsoft Exchange server, and I use Outlook as the client...

Thanks,
Bruce

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
One more thought from the Health team - is it possible you set the
Contact to receive Pages and not e-mail? Pages only have a subject line
in the e-mail indicating that there is an alarm or warning. There is no
more info. This matches with what you are saying. If you set the Contact
to recieve e-mail, then you will get a lot more info on the HI, values,
history, etc.

Bruce MacDonald wrote:
Blair,

Thanks very much - that's exactly what I was looking for!

Bruce
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:bn**********@hanover.torolab.ibm.com...
> I think you have to run a utility called db2updv8. You can search
> on it
> (or HEALTH_CONT_HI) here:
> http://publib.boulder.ibm.com/infoce...help/index.jsp
>
> I'll pass on your concerns about the e-mail.
>
> Bruce MacDonald wrote:
>
>
>
>> I am unable to see the health monitor SQL table functions (e.g.:
>> SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the
>> functions? DB2 8.1.3.132 WR21324.
>>
>> Another point about the health monitor - when I get notification
messages
>> all they say is that a particular instance/db has a warning or alarm.

I
>> have to open the health centre to see what the actual warning / alarm
is. I
>> would much prefer if the email had at least a hint as to the
>> nature of
ther
>> warning / alarm.
>>
>> TIA,
>> Bruce
>>
>>
>



Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.