Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Smile Unanswered: HADR status checkup

    Hi,

    db2 v8.1.12.99 FP 12.

    We have setup the HADR between Primary and Standby server today and performing well as expected. Now the question is

    How can we automate to check that the HADR is working / connected?

    Which SYSIBM table keep all this information? Please post your suggestions.

    Thanks. Dun

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It is not in the catalog. But you can get status in one of two ways:

    1. get snapshot for database (there is an HADR section)

    2. db2pd -db sample -hadr
    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
    Dec 2008
    Location
    Chennai
    Posts
    111

    HADR check

    Yes, I can see the status using db2pd. really good one.

    Thanks Marcus.

Posting Permissions

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