Skip to Content
Former Member
May 12, 2010 at 05:30 AM

DB2 HADR Failover Scenerio



We have set up HADR.

Primary -> Production Server

Standby -> DR Server

My Question is, for example if there is a temporary OS problem in my Production Server and the OS Crashed, I will make the Standby DB, the Primary, BY FORCE.

After the OS Problem is solved. I start db2 and activate the database. After that can I make the original Primary db, the Standby to join the HADR pair by issuing - START HADR ON DB SEP AS STANDBY ?

If YES, How is that possible? Because as far as I know the DB has to be in "Rollforward Pending" state to become the Secondary. And our original Primary DB will never be in that Roll Forward Pending state.

If NO, what should be the approach to handle this kind of scenerios?