472,121 Members | 1,604 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

db2 health monitor alert action to run script

i am trying to use the db2 health monitor alert to run a script. i set
up the health monitor to run a script when the tablespace utailization
is too high. in the end, the script should send a syslog message. for
now, i am just trying to figure out what message db2 is sending, by
printing out the parameters db2 is sending.

set up:

Indicator Name = ts.ts_util
Default = No
Type = Threshold-based
Warning = 60
Alarm = 90
Unit = %
Sensitivity = 0
Formula =
Actions = Enabled
Threshold or State checking = Enabled

Script pathname =
Condition = Warning
Script type = OS
System =
Working directory =
Command line parameters = space
Userid = userid
Contents of ts_util.script:
# Handle tablespace utilization warnings
cat $1 >> tempfile;
When the health alert is triggered, I get the following in db2diag.log:

2005-10-31- Instance:userid Node:000
PID:6256(db2hmon 0) TID:4 Appid:none
Health Monitor HealthIndicator::update Probe:500

ADM10501W Health indicator "Table Space Utilization" ("ts.ts_util")
the "upper" warning threshold of "60 %" with value "71 %" on "table
"userid.TEST .SYSCATSPACE". Calculation:
"((ts.ts_used_pages/ts.ts_usable_pages)*100);" = "((28192 / 39968) *
100)" =
"71 %". History (Timestamp, Value, Formula): "()"

2005-10-31- Instance:userid Node:000
PID:6256(db2hmon 0) TID:17 Appid:none
Health Monitor HealthIndicator::update Probe:1500

ADM10504E The health monitor failed, with sqlcode "4404", to initiate
an alert
action, running "script"
"/export/home/userid/health_scripts/ts_util.script" on
system "SYSTEMNAME", when the Health Indicator "Table Space
Utilization" ("ts.ts_util") went into the "Warning" alert state on
space" "userid.TEST .SYSCATSPACE".
Any thoughts as to why I am getting that error? the permissions on the
script file are wrx for all. I have been unable to find the format of
the db2 alert message sent. Thanks in advance.

Nov 12 '05 #1
0 3304

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Bruce MacDonald | last post: by
3 posts views Thread by Debbie E | last post: by
2 posts views Thread by Debbie E | last post: by
2 posts views Thread by Mike | last post: by
reply views Thread by nycjay | last post: by
4 posts views Thread by Maddy | last post: by
1 post views Thread by datapro01 | last post: by
reply views Thread by leo001 | last post: by

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.