Results 1 to 4 of 4

Thread: HADR Sync

  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: HADR Sync

    RHEL 6.2 - DB2 9.5 FP 8.

    Is there a way to find out if the 2 HADR databases (Primary and Standby) are in sync without failing over ?

    Thank you.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    db2pd -d <db-name> -hadr

    First you want to make sure the servers are in Peer State and Connected.

    Then examine the log addresses for Primary and Standby. The may be exactly the same (in which case they are exactly in synch) or the standby can be slightly behind the primary if there is a lot of activity going on. If they are not exactly in synch, but close, you can rerun the command to see if both the log addresses are increasing, which means they are probably OK.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2004
    Posts
    268
    Thank you Marcus. They are always in "peer" status but examining the logs is good idea. I gues there is no other way like a query or some other indicator. I have a SQL Server background where database sync is a job that runs on request/schedule bases.

    Thanks again.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by mdx34 View Post
    Thank you Marcus. They are always in "peer" status but examining the logs is good idea. I gues there is no other way like a query or some other indicator. I have a SQL Server background where database sync is a job that runs on request/schedule bases.

    Thanks again.
    The log addresses are in the output of the db2pd command I gave you.
    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
  •