75 ways to demystify DB2: # 35: Upgrading DB2 servers in an automated HADR environment
RafatOdeh 2000004M6C Comment (1) Visits (6146)
In an automated High Availability Disaster Recovery (HADR) environment, rolling upgrade procedure will not work when upgrading from an earlier to a later version of a DB2 database system. For example, you cannot use this procedure to upgrade from a DB2 Version 9.7 to Version 10.x. Use this procedure in an automated HADR environment when you upgrade your DB2 versions 10.1 and 10.5 from DB2 Version 9.7. The following steps must be completed:
db2 stop hadr on database sample
2. Verify the database role has been changed to standard on both servers using :
db2 get db cfg for sample | grep -i role
3. Delete the cluster domain using db2haicu command. For example;
4. Deactivate the database on both the the standby and primary servers. For example
db2 deactivate db sample
5. Stop DB2 instance by using db2stop command.
Where DB2DIR represents the installation location of the new release of the DB2 database system is installed.
8. As the instance owner, start the DB2 instance by using the db2start command.
db2 upgrade database sample
10. Reinitialize HADR by following the steps documented on this link:
11. Once the HADR has been reestablished, the cluster domain resources must be re-created. See the "Automated HADR configuration setup" whitepaper for more information under the link: