IBM Support

How to remove existing HADR configuration

Technote (FAQ)


How to remove HADR configuration?


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

Document information

More support for: DB2 for Linux, UNIX and Windows
OTHER - Uncategorised

Software version: 9.5, 9.7, 10.1

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

Reference #: 1621453

Modified date: 18 November 2015