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

Add comments

Document information


More support for:

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

Machine Translation

Content navigation