Steps to configure HADR Environment in DB2

-

DB2 high availability disaster recovery (HADR) is a data replication feature that provides a high availability solution for both partial and complete site failures. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.

 

Step 1:

Create 2 DB2 Instances(db2inst1,db2inst2)
Create Instance 1 by typing "db2icrt  -u db2fenc1 db2inst1"
Create Instance 2 by typing "db2icrt -u db2fenc2 db2inst2"

Note: The parameter logarchmeth1 should be enabled on these 2 instances, because the backup supports archival logging.

 

Step 2:

Configure Instance 1
Type the following commands:

db2set DB2COMM=TCPIP
db2 update dbm cfg using SVCENAME 50000
db2start

 

Step 3:

Configure Instance 2

Type the following commands:
db2set DB2COMM=TCPIP
db2 update dbm cfg using SVCENAME 50004
db2start

Step 4: Create the Primary DB in Instance 1
Type the following commands:

SET DB2INSTANCE=DB2INST1
db2 create db SAMPLE
db2 update db cfg for SAMPLE using LOGINDEXBUILD on
db2 update db cfg for SAMPLE using INDEXREC RESTART
Note: This step will turn the DB into archival logging mode

Step 5: Create a backup of Primary DB
Type the following commands:
db2 BACKUP DB SAMPLE (It will store in your present directory)

Step 6: Restore the backup SAMPLE as Standby database

Type the following commands:
SET DB2INSTANCE=DB2INST2
db2 RESTORE DB SAMPLE

Note: This step will restore the database as SAMPLE in the second DB2 instance and place it into roll forward pending state.

Note: If you roll forward the SAMPLE now, you will not be able to initialize it as the standby database.

Step 7: Configure the HADR settings for the Primary DB in DB2INST1

Type the following commands in the first instance:

db2 update db cfg for SAMPLE using hadr_local_host localhost

db2 update db cfg for SAMPLE using hadr_local_svc 50000
db2 update db cfg for SAMPLE using hadr_remote_host remotehost
db2 update db cfg for SAMPLE using hadr_remote_svc 50004
db2 update db cfg for SAMPLE using hadr_remote_inst DB2INST2

 

Type the following commands in the second instance:

 

db2 update db cfg for SAMPLE using hadr_local_host localhost
db2 update db cfg for SAMPLE using hadr_local_svc 50004
db2 update db cfg for SAMPLE using hadr_remote_host remotehost
db2 update db cfg for SAMPLE using hadr_remote_svc 50000
db2 update db cfg for SAMPLE using hadr_remote_inst DB2INST1

Note: Primary SAMPLE HADR service port will be 50000.
Note: Standby SAMPLE HADR service port will be 50004.


Warning: You cannot use the Instance TCPIP port (SVCENAME) or next port number (SVCENAME+1) as the HADR service port. This is by design.
Now, you are ready to test the configuration.


Step 8: Start HADR on Standby DB IN DB2INST2
SET DB2INSTANCE=DB2INST2
db2 START HADR ON DB SAMPLE AS STANDBY
Step 9: Start HADR on Primary DB IN DB2INST1

SET DB2INSTANCE=DB2INST1
db2 START HADR ON DB SAMPLE AS PRIMARY

Step 10: Take over the Primary Role to Standby Instance
SET DB2INSTANCE=DB2INST2
db2 TAKEOVER HADR ON DB SAMPLE

Step 11: Take back the Primary Role from Standby Instance
SET DB2INSTANCE=DB2INST1
db2 TAKEOVER HADR ON DB SAMPLE

Step 12: Stop the HADR service on Primary DB
SET DB2INSTANCE=DB2INST1
db2 deactivate db SAMPLE
db2 STOP HADR ON DB SAMPLE
Step 13: Stop the HADR service on Standby DB

SET DB2INSTANCE=DB2INST2
db2 deactivate db SAMPLE
db2 STOP HADR ON DB SAMPLE

Comments

Post a Comment

Popular posts from this blog

Difference between DB2 Terminate and Connect Reset

-
db2 Terminate  and  db2 connect Reset  both break the connection to a database. Connect Reset breaks a connection to a database, but does not terminate the back-end process. The Terminate command does both  break the connection to a database and terminate the back-end process. db2 list applications Auth Id Application Name Appl. Handle Application Id DB Name # of Agents ------- -------------- ---------- ------------------------------ -------- ----- S1 db2jcc.exe 1 *LOCAL.DB2.10000 EMP 1 TEST db2jcc.exe 2 *LOCAL.DB2.20000 EMP 1 Now you can use  db2 "force applications all"  This command is used to kill all the applications forcefully at instance level . To force a particular application with application handle 1 db2  "force application(1)"
Read more

Db2 export command example using file format (del , ixf)

-
You want to transfer data from a db2 database table to another db2 database or within the same database, one of the way is to use db2 export / import command. Using db2 export / import you can move your data to excel also.   DB2 export command exports data selected by SQL statement from a table or view to an external files in the format of  del - delimited , wsf - worksheet format , ixf - Integration Exchange Format,asc.   The DEL format uses delimiter and column separator and decimal point. The default string delimiter is double quote " and column separator is comma(,) and Decimal Point is dot(.), you can also specify your own string delimiter & column separator, decimal point. Another format supported by DB2 is   IXF (Integration Exchange Format). It is a generic relational database exchange format which supports an end-of-record delimiter . IXF architecture supports to exchange of relational database structures and data. IXF is used for transferring data ...
Read more

Database recovery methods

-
 Backup and recovery Following, there are four utilities supported within Db2 to facilitate backing up and restoring a database: The backup utility The restore utility The roll-forward utility The recover utility   The backup utility: The backup utility is used to create images outside the database that can be used to recover the entire database or a portion of it. If the database is an archive logging enabled database, the backup utility can be executed online with multiple concurrent applications connected to the database. The backup utility uses the utility heap to copy the data from the table spaces to the backup image. The utility heap can be controlled via the database configuration parameter UTIL_HEAP_SZ. The backup utility can write the backup image to storage devices on the database server, to a tape device, or can copy the data directly to the TSM storage devices or another vendor-supplied routine. Execute the BACKUP command to start the backup process. The basic syn...
Read more