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).
Related Information
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21621453