{"id":1409,"date":"2013-02-20T21:01:43","date_gmt":"2013-02-20T15:01:43","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=1409"},"modified":"2016-01-07T11:31:03","modified_gmt":"2016-01-07T05:31:03","slug":"checking-on-hadr","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=1409","title":{"rendered":"Checking on HADR"},"content":{"rendered":"<p>By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution. \u00c2\u00a0IBM has matured HADR over the last two versions and its becoming more and more robust. \u00c2\u00a0Couple of years ago I had written an article on <a href=\"https:\/\/techsatwork.com\/blog\/?p=1033\" target=\"_blank\">how to setup HADR<\/a>\u00c2\u00a0which I know many of you used. The instruction hasn&#8217;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.<\/p>\n<p>As always verify the script \u00c2\u00a0before you implement it in your system. You can download the script here :\u00c2\u00a0<a href=\"https:\/\/techsatwork.com\/blog\/wp-content\/uploads\/2013\/02\/hadr_checker.sh_.txt\">hadr_checker.sh<\/a><\/p>\n<p>Please feel free to comment on the script and ways to improve it.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution. \u00c2\u00a0IBM has matured HADR over the last two versions and its becoming more and more robust. \u00c2\u00a0Couple of years ago I had written an article on how to setup HADR\u00c2\u00a0which I know many of you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[303,3,358],"tags":[857,94,856,186,576,855],"class_list":["post-1409","post","type-post","status-publish","format-standard","hentry","category-database","category-db2","category-how-to","tag-check-hadr","tag-db2-hadr","tag-db2-high-availability","tag-db2pd","tag-hadr","tag-hadr-status"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1409"}],"version-history":[{"count":2,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions"}],"predecessor-version":[{"id":1412,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions\/1412"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}