Skip to main contentIBM Db2 dsmtop Wiki

Other - HADR

Purpose

HADR stands for High Availability Disaster Recovery, which is a technology used for protecting your database against data loss and allows the database to be highly available through partial or complete site failure. HADR is achieved by replicating data changes from one database (the primary) to another (the standby). When the primary database encounters a failure, the standby database can take over and become the new primary database.

This view is available only if the database is configured as an HADR database.  dsmtop can monitor the primary or the standby, but only if reads on standby (ROS) is enabled.

HADR-Primary.png

Summaries and Histograms (Gauges)

Log Writes

Log wtime

 

Log IOs

Log Buff

Rf type

Type of object. One of:

  • DATABASE
  • INDEX
  • PARTITIONGROUP
  • TABLE
  • TABLESPACE
  • VIEW

Source: mon_get_utility.object_type

Rf status

Metrics Shown


General

Role

Standby ID

Log stream ID

Log gap

HADR Flags

Error time


Connection

State

Status

Time

Mode

Hearbeat

Timeout

Peer window


Primary

Host

Instance

Member

Log file

Log page

Log LSN

Log time


Standby

Host

Instance

Member

Log file

Log page

Log LSN

Log time


Replay

Log file

Log page

Log LSN

Log time

RR gap

Default Sort Column

N / A - This is a tile display, not a grid.

Keyboard Navigation: VoA

Dedicated shortcut key: alt-A

Author: KevinLBeck