Checking on HADR
By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution. Â IBM has matured HADR over the last two versions and its becoming more and more robust. Â Couple of years ago I had written an article on how to setup HADRÂ which I know many of you used. The instruction hasn’t changed over the versions, but several of you have recently asked me for a script to check HADR status. Here is a simple script that will check on HADR status on each database on the instance and email the status.
As always verify the script  before you implement it in your system. You can download the script here : hadr_checker.sh
Please feel free to comment on the script and ways to improve it.