IBM Support

How to remove existing HADR configuration

Question & Answer


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).

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"HADR - Other","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21621453