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

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

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

Thanks Marcus.