Skip to Content
avatar image
Former Member

IBM DB2 HADR Standby fail

Hi Sap Gurus,

We have setup on IBM DB2 10.05 HADR on AIX 7.1, but standby database the lastest transaction timestamp or received logs on standby database was 01/10/2017 12:23:02 (January 10). How to make to update standby database again?

Best regards,

Anderson C.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 17, 2017 at 01:42 PM

    Hi Anderson,

    I presume HADR is down, so first thing you can do is to try starting the database as standby. If the remote catchup works then you are in business... if it doesn't then the best thing to do is to restore from a backup of the primary and start the standby again.

    Is there any particular error you are getting?

    Regards, JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2017 at 02:59 PM

    Hi Juan,

    Thanks for your answer. The hadr_state is remote_catchup, but the standby database is down continously becauseprimary_log_time and standby_replay_log_time are since 01/10/2017.

    Enclose picture.

    db2-start-hadr.png

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2017 at 02:29 PM

    Any error on the db2diag.log?

    have you try to stop and start HADR?.... having said that if you not keeping all the archived logs since January you might as well restore from primary and re-enable HADR

    Regards, JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 19, 2017 at 04:15 PM

    Hi Juan.

    Do you know if can i restore from redirect method and then re-enable HADR.

    Add comment
    10|10000 characters needed characters exceeded