Technote (FAQ)
Question
How to remove HADR configuration?
Answer
Use the following procedure to remove your current settings for HADR configuration:
1- Stop HADR in both servers (Primary and StandBy)
stop hadr on database <database>
2- Clean up the HADR configuration parameters from both databases:
HADR_LOCAL_HOST: HADR local host name
HADR_LOCAL_SVC: HADR local service name
HADR_REMOTE_HOST: HADR remote host name
HADR_REMOTE_SVC: HADR remote service name
HADR_REMOTE_INST: HADR instance name of remote server
You can use the commands below (note that NULL must be in UPPER case):
db2 "update db cfg for <database> using HADR_LOCAL_HOST NULL "
db2 "update db cfg for <database> using HADR_LOCAL_SVC NULL "
db2 "update db cfg for <database> using HADR_REMOTE_HOST NULL "
db2 "update db cfg for <database> using HADR_REMOTE_SVC NULL "
db2 "update db cfg for <database> using HADR_REMOTE_INST NULL"
Please note that you need to execute the above commands for both databases (Primary and StandBy).
Related information
Stopping DB2 High Availability Disaster Recovery (HADR)
STOP HADR command
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.