Skip to main content

How to remove existing HADR configuration


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:

(0 users)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.

Rate this page:


(0 users)Average rating

Add comments

Document information

DB2 for Linux, UNIX and Windows


Software version:
9.5, 9.7, 10.1


Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows


Reference #:
1621453


Modified date:
2013-02-22

Translate my page

Content navigation