473,378 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

sending health monitor messages to another application

hello,
i am just getting started as a dba. ny current task is to set up
notification for health alerts. so, we have the health monitor running,
and it is currently putting health alerts (space usage, runstat
warnings, etc) into the normal db2diag logs. as i understand it, we can
set up the admin server (das?) to send an email or page to a dba when
one of these health alters is triggered. what we are trying to do is
slightly different though. we have our own system management
application running on another server. we would like to get the db2
health alerts sent over to this application. i could write a perl
program or something like that to periodically go through the db2diag
log file and look for health alters, but i would like to avoid that if
possible. is there a way to set up db2 (i have not yet seen it in the
documentation) to allow db2 to send messages to another application,
via smtp or another mechanism? thanks in advance.

Nov 12 '05 #1
3 1717
You can use health indicator table functions:

EALTH_CONT_HI,
HEALTH_DB_HI,
and many others.

Your application can connect to monitored database and get the required
information directly.

-- Artur Wronski

Nov 12 '05 #2
i guess what we were looking to be able to do is have db2 send a udp or
smtp message to our management application (on another sever) when an
alert is triggered, so we don't have to connect to db2 and check for
errors every x number of minutes

Nov 12 '05 #3
err, snmp, not smtp

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Bruce MacDonald | last post by:
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...
2
by: Debbie E | last post by:
Are there any issues with the Health Monitor in a partitioned environment? I have turned on the health monitor and can obtain the health snapshot for the DBM via the following command: get...
2
by: Mike | last post by:
Hellos again, I seem to be having a weird issue. Whenever DB2 Health monitor seems to run, all connections to the database seem to just lock up. For example: (and this seems consistent) In list...
4
by: Maddy | last post by:
Hi all, I am new to DB2 database.I just have the basic knowledge abt this database.I in a serious situation of handling 5 large databases.Can some one help me how to prepare the health check...
1
by: rdudejr | last post by:
How often does the health monitor check the threshold of an indicator to see if there is a warning or alarm? I am trying to simulate the behaviour of the health monitor and have a dms tablespace...
1
by: oddbande | last post by:
I get a lot of these messages in db2diag.log - seems like problems with health Monitor: 2007-01-05-15.05.06.380000+060 I260759H331 LEVEL: Severe PID : 3860 TID : 4004...
4
by: onedbguru | last post by:
DB2Connect Informational tokens are "DB2 v8.1.0.96", "s050811", "U803921", FixPak "10". I am getting txxxxxx.0000 files approximately every 14 minutes that look like: <Trap> <Header> DB2...
0
by: Cage | last post by:
hi,all As we known,DB2 Health Center is a very good tool,but it made me a little confusion. I will be very appreciate if anyone give me some advices. The problem is that I want to monitor my...
5
by: jbenner | last post by:
I have opened a PMR for this with IBM, and am not asking for advice from the DB2 DBA community. I am posting this as an FYI that DB2 Health Monitor, even at the latest version of DB2, still can cause...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.