The following steps have been verified in ITIM Performance Labs.
Steps to set up primary HADR
Enable logretain:
db2 update db cfg for ITIMDB using logretain on
Enable logindexbuild:
db2 update db cfg for ITIMDB using logindexbuild on
Set indexrec:
db2 update db cfg for ITIMDB using indexrec restart
Backup primary db:
db2 backup db ITIMDB to <directory backup location>
Catalog remote instance:
db2 catalog admin tcpip node second remote <standBY_IP ADDR> system second ostype <os_type>
db2 catalog tcpip node second remote <standBy_TP ADDR> server <standBY_port_num> remote_instance <remote_inst_name>
db2 catalog db ITIMDB as secITIMDB at node second
Config HA-DR Parameters
db2 update db cfg for ITIMDB using HADR_LOCAL_HOST <Primary_IP>
db2 update db cfg for ITIMDB using HADR_LOCAL_SVC DB2_HADR_P
db2 update db cfg for ITIMDB using HADR_REMOTE_HOST <standBy_IP>
db2 update db cfg for ITIMDB using HADR_REMOTE_SVC DB2_HADR_S
db2 update db cfg for ITIMDB using HADR_REMOTE_INST <remote_inst>
db2 update db cfg for ITIMDB using HADR_SYNCMODE nearsync
db2 update db cfg for ITIMDB using HADR_TIMEOUT 120
Primary - Update the services file
DB2_HADR_P <primary_port>/tcp
DB2_HADR_S <standby_port>/tcp
Update alternate server information
db2 update alternate server for database ITIMDB using hostname <standby IP> port <standby_portNum>
Steps to set up secondary HADR
restore database on secondary:
db2 restore db itimdb from <primary backup location> replace history file
Enable logretain:
db2 update db cfg for ITIMDB using logretain on
Enable logindexbuild:
db2 update db cfg for ITIMDB using logindexbuild on
Set indexrec:
db2 update db cfg for ITIMDB using indexrec restart
Config HA-DR Parameters
db2 update db cfg for ITIMDB using HADR_LOCAL_HOST <secondary IP>
db2 update db cfg for ITIMDB using HADR_LOCAL_SVC DB2_HADR_S
db2 update db cfg for ITIMDB using HADR_REMOTE_HOST <primary IP>
db2 update db cfg for ITIMDB using HADR_REMOTE_SVC DB2_HADR_P
db2 update db cfg for ITIMDB using HADR_REMOTE_INST <remote_inst_name>
db2 update db cfg for ITIMDB using HADR_SYNCMODE nearsync
db2 update db cfg for ITIMDB using HADR_TIMEOUT 120
Standby - Update the services file
DB2_HADR_P <primary_port>/tcp
DB2_HADR_S <standby_port>/tcp
start HADR on standby database
db2 start hadr on database ITIMDB as standby
Update alternate server information
db2 update alternate server for database ITIMDB using hostname <primary IP> port <primary_portNum>
start HADR on standby first
db2 start hadr on database ITIMDB as standby
Start HADR on primary
db2 start hadr on database ITIMDB as primary