Upgrading DB2 in HADR environment
Hi All,
We are planning for upgrading DB2 databases from 10.5 fixpack 8 to 11.1. Currently we have setup as below ;
Two servers one hosting the primary(PROD Server) databases and other server(Stagging) hosting standby databases. We have went through few articles for uprading DB2 databases in HADR environment however most of the articles suggests us upgrading primary databases first and then upgrading the standby databases. However in our case as we do not have test environment we do all our testing in Stagging server so here we are planning to upgrade DB2 instance in Stagging server first and if everthing goes fine we will move to upgrade in PROD server. Below are queries :
Can we stop Repliction(HADR) and upgrade Stagging server DB and then upgrade PROD server DB2.
Thanks,
Kunal
Accepted answer
Hi Kunal,
You indicate that "Two servers one hosting the primary(PROD Server) databases and other server(Stagging) hosting standby databases."
In a typical HADR environment, the Primary and Standby pair (together) would be considered a single entity.
So, if you had HADR setup for Production, then you should have a Primary (PROD), and Standby (PROD).
Similarly, if you want to enable HADR for a staging environment, you would have Primary (STAGING), and Standby (STAGING)
Have you engaged the Db2 team to discuss your upgrade steps for HADR? I would recommend you doing that.
Regards,
Anthony.