Incident Management Context and Intelligence

 View Only
Expand all | Collapse all

DB2 - HADR - HADR_FLAGS can be Monitored and Alerted/Notified ?

  • 1.  DB2 - HADR - HADR_FLAGS can be Monitored and Alerted/Notified ?

    Posted Wed June 28, 2023 01:19 PM
    Edited by System Test Fri May 24, 2024 11:46 AM

    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
    ------------------------------



  • 2.  RE: DB2 - HADR - HADR_FLAGS can be Monitored and Alerted/Notified ?

    Posted Fri July 07, 2023 12:56 PM

    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

    Event I
    Event II
    Event III


    ------------------------------
    Tom Tammann
    ------------------------------