Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005

    Unanswered: db2 health monitor

    Looking at the health monitor for HADR health indicators:
    One of them being:
    Indicator Name = db.hadr_delay
    Default = Yes
    Type = Threshold-based
    Warning = 10
    Alarm = 15
    Unit = Minutes
    Sensitivity = 0
    Formula = (db.hadr_log_gap*var.refresh_rate/60)DIV(delta(db.hadr_secondary_log_pos));
    Actions = Disabled
    Threshold or State checking = Enabled

    Was wondering where db2 gets the values for the variables in the formula used to calculate db.hadr_delay.

    Thank you in advance.

  2. #2
    Join Date
    May 2003
    Database snapshot has the log postion on the primary and standby database at any given time. The snapshot also provides an average log gap number.

    I assume the refresh rate has something to do with how often the health monitor is checking these numbers.

    You can probably get the same numbers with db2pd command using the HADR option (but I will let you check that one out).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts