Hi Mauricio
thanks for reaching out.
If it's not documented it's not supported. However, we have a build-in event (see screenshots) which indicates is checks that flag and raises an issue based on it.
Could you please check on your events page if you see such errors?
The filter is
event.specification.id:EwlLtM4RRzAIAmE8DWa8-DtAKEY
Let me know if this works.
Cheers
Tom
------------------------------
Tom Tammann
------------------------------
Original Message:
Sent: Tue June 27, 2023 02:56 PM
From: Mauricio Borges
Subject: DB2 - HADR - HADR_FLAGS can be Monitored and Alerted/Notified ?
Hi Team!
According to Instana documentation, sounds "HADR_FLAGS" metric is not collected, correct ?
When a tablespaces is invalid or error state on the Standby database, the HADR_FLAGS field will display
the value STANDBY_TABLESPACE_ERROR.
Example:
Database Member 0 -- Database DB -- Active -- Up 29 days 01:24:49 -- Date 2023-06-27-18.43.18.189141
HADR_ROLE = PRIMARY
HADR_SYNCMODE = NEARSYNC
HADR_STATE = PEER
HADR_FLAGS = STANDBY_TABLESPACE_ERROR
PRIMARY_MEMBER_HOST = xxxxxx.cpc.ibm.com
STANDBY_MEMBER_HOST = yyyyyy.cpc.ibm.com
HADR_CONNECT_STATUS = CONNECTED
HADR_FLAGS can be Monitored and Alerted/Notified ?
Appreciate any help !
References:
hadr_connect_status - HADR Connection Status monitor element
Monitoring IBM Db2
------------------------------
Mauricio Borges
------------------------------