IBM®
Skip to main content
    Country/region [select]      Terms of use
 
 
    
     Home      Products      Services & industry solutions      Support & downloads      My IBM     
developerworks > Community >  Dashboard > Tivoli Identity Manager > ... > Setting up HA and DR environments for ITIM 5.x > DB2 HA Configuration Steps
developerWorks
Log In   View a printable version of the current page.
DB2 HA Configuration Steps
Added by NnaEmekaEmejulu, last edited by NnaEmekaEmejulu on Nov 29, 2011  (view change)
Labels: 
(None)

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


    About IBM Privacy Contact