If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

1. When secondary starts up again, I need to run 'start HADR on database _____ as standby' - then all will work ok?
2. When Primary comes back up, it will automatically restart HADR as primary - no action required?
3. When both come back up - I need to start HADR on standby *before* db2start on the primary?

(I have left out the scenarios where primary starts up after standby has taken over, as in this case, the old primary will automatically start up as standby)

DB2 databases are not activated automatically upon their instance start up. You have to do it explicitly or implicitly (when, for example, some user application is trying to connect to the database). DB2 database "remembers" it's previous HADR role upon activation. So, if you issue ACTIVATE DATABASE command (or your application tries to connect), the database tries to take it's previous role.
HADR Primary is not activated until it connects to Standby. It returns an error if it's not able to connect in HADR_TIMEOUT seconds.
This is why you should activate (via ACTIVATED DATABASE or START HADR AS STANDBY) Standby before trying to activate Primary.

When the Primary tries to connect to the standby, will this activate the standby?

Originally Posted by mark.b

Hi Jason,

DB2 databases are not activated automatically upon their instance start up. You have to do it explicitly or implicitly (when, for example, some user application is trying to connect to the database). DB2 database "remembers" it's previous HADR role upon activation. So, if you issue ACTIVATE DATABASE command (or your application tries to connect), the database tries to take it's previous role.
HADR Primary is not activated until it connects to Standby. It returns an error if it's not able to connect in HADR_TIMEOUT seconds.
This is why you should activate (via ACTIVATED DATABASE or START HADR AS STANDBY) Standby before trying to activate Primary.