# IBM DB2 metrics from HADR

**URL:** <https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749>\
**Category:** Extensions\
**Tags:** databases, dynatrace-managed, ibm, extensions\
**Created:** [March 10, 2021, 5:32pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749 "2021-03-10T17:32:02Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![borgesm](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/borgesm/32/32366_2.png) [@borgesm](https://community.dynatrace.com/u/borgesm)\
**Post date:** [March 10, 2021, 5:32pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/1 "2021-03-10T17:32:02Z")

</div>

Hello team!

I am exploring [DB2 extension](https://www.dynatrace.com/support/help/technology-support/application-software/other-technologies/dynatrace-extension-required/ibm-db2/), but couldn’t find metrics about HADR.  
This is one interesting Alerting used to our legacy monitoring to check HADR State to ensure they are in PEER State, then if not generates an Alert.

This is currently feasible on Dynatrace?

Any way to get Metric information from servers with HADR enabled?

Thanks, Mauricio

---

<div class="post-metadata">

**Author:** ![MichalGebacki](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/michalgebacki/32/41585_2.png) [@MichalGebacki](https://community.dynatrace.com/u/MichalGebacki)\
**Post date:** [January 10, 2022, 3:01pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/2 "2022-01-10T15:01:32Z")

</div>

Welcome everyone!

Does anyone have some tips on this thread? All help is really appreciated!

---

<div class="post-metadata">

**Author:** ![Ben\_Knust](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ben_knust/32/39431_2.png) [@Ben\_Knust](https://community.dynatrace.com/u/Ben_Knust)\
**Post date:** [March 23, 2022, 11:08pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/3 "2022-03-23T23:08:17Z")

</div>

Hi borgesm,

have you found a solution for the problem to monitor PEER State of HADR with Dyntrace ?

Would be interested to hear about it.

Thanks,

Ben

---

<div class="post-metadata">

**Author:** ![borgesm](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/borgesm/32/32366_2.png) [@borgesm](https://community.dynatrace.com/u/borgesm)\
**Post date:** [March 24, 2022, 12:55pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/4 "2022-03-24T12:55:08Z")

</div>

Not I am aware of. However I hope Dynatrace Support team can look on it and give us some response!  
There are many features that DB2 Extension could be improved!  
Below some tips that Extension could add (&nbsp; metrics to be collected ) by default if enabled.

> **[db2pd -hadr - Db2 HADR Wiki](https://ibm.github.io/db2-hadr-wiki/hadrMonitoring.html#db2pd__hadr)**
>
> "db2pd -hadr" option returns HADR info for a database. It is light weight, requiring no SQL connection. But it can only be issued on the database host machine (it attaches to DB2 server shared memory). In DB2 V10.1 and later , the output is like

---

<div class="post-metadata">

**Author:** ![Ben\_Knust](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ben_knust/32/39431_2.png) [@Ben\_Knust](https://community.dynatrace.com/u/Ben_Knust)\
**Post date:** [March 24, 2022, 1:01pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/5 "2022-03-24T13:01:27Z")

</div>

Thanks ! I found this page also yesterday and had a look at it. I also saw your Idea request for Dynatrace and left a like. If there is any other way to support your Idea please tell me and I will also leave some likes / comments there 🙂

I will raise the topic also in our Teams.

---

<div class="post-metadata">

**Author:** ![Ben\_Knust](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ben_knust/32/39431_2.png) [@Ben\_Knust](https://community.dynatrace.com/u/Ben_Knust)\
**Post date:** [March 24, 2022, 1:03pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/6 "2022-03-24T13:03:28Z")

</div>

Idea request from borgesm for DB2 extension monitoring HADR.

[https://community.dynatrace.com/t5/Dynatrace-product-ideas/IBM-DB2-Metrics-and-Alerts-for-HADR/idi-p/162762](https://community.dynatrace.com/post/162762)

---

<div class="post-metadata">

**Author:** ![vagiz\_duseev](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/vagiz_duseev/32/39484_2.png) [@vagiz\_duseev](https://community.dynatrace.com/u/vagiz_duseev)\
**Post date:** [April 6, 2022, 3:31pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/7 "2022-04-06T15:31:49Z")

</div>

Hi borgesm,

Indeed, those metrics could be added to the existing DB2 extension for ActiveGate. According to the official docs, we can retrieve them from the [MON\_GET\_HADR](https://www.ibm.com/docs/en/db2/11.5?topic=mpf-mon-get-hadr-get-high-availability-disaster-recovery-hadr-monitoring-information)&nbsp;table functions.  
However, I wouldn’t expect them anytime soon. Alternatively, you can always reach out to [extension@dynatrace.com](mailto:extension@dynatrace.com)&nbsp;team to implement that as a custom addition to the existing plugin.

Hope that this information helps!

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [April 6, 2022, 7:28pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/8 "2022-04-06T19:28:47Z")

</div>

Hi&nbsp;[@vagiz\_duseev](https://community.dynatrace.com/user/3741)&nbsp;, good day. How can we request this to extension team? Just dropping them an email, or a ticket need to be open on&nbsp;[https://one.dynatrace.com/hc/en-us/requests](https://one.dynatrace.com/hc/en-us/requests),&nbsp;or just here on Community as a RFE, as [done here](https://community.dynatrace.com/post/162762)?

Thanks.

---

<div class="post-metadata">

**Author:** ![Mike\_L](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mike_l/32/11717_2.png) [@Mike\_L](https://community.dynatrace.com/u/Mike_L)\
**Post date:** [April 6, 2022, 8:21pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/9 "2022-04-06T20:21:07Z")

</div>

The extensions team is a paid services that will charge the creation of the functionality by the day. If that’s not what you’re looking for you can always create an RFE on the community and wait for it to be picked up.

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [April 7, 2022, 12:02pm UTC](https://community.dynatrace.com/t/ibm-db2-metrics-from-hadr/30749/10 "2022-04-07T12:02:53Z")

</div>

Oh , got it now. Thanks&nbsp;[@Mike\_L](https://community.dynatrace.com/user/11520)
