HADR monitoring with custom scripts

[deshaipet]

db2level = V97 FP 2.
Oslevel = AIX 6.1 TL 03.
TSAMP level = 3.1 FP 06

Hi,

In todays world we have TSAMP HADR monitoring scripts which monitoring scripts to monitor failures in HADR system. But we dont get email alerts when a failover occured or when a instance is down and some other cases.

questions :

What could be the best method to monitor these ?


Thanks,
Panditt

[vijay2082]

Hi,

There is plethora of options avaiable for monitoring it with an SMS alert depending on how much your organisations can afford on the options out there.

First of all check in your scripts for providing/sending a mail to the user/group on a failure. Below are some of the options that can be used in your situation :

1) HPOV with DPSPI to send mail alerts in general and for database specific alerts
2) NAGIOS for Mail as well as SMS alert *

* Sometimes if failover is within seconds then the particula software won;t be able to capture the fail and send SMS alert. In such cases you can always browse through the logs and send alert based on log file monitoring through HPOV or manual scripting

[deshaipet]

Thanks a lot Vijay.

Thanks,
Panditt

[vijay2082]

Cheers, Vijay