Db2 synchronization between 2 servers

arun26081983 · #1 (**permalink**) 09-28-09, 11:37

Hi,

in our environment, we have 2 Solaris servers with DB2 V 9.1 fp 7.
There is a process which writes data into DB2, but the second server being just a backup server for all the applications of first server (including DB2) there is no data written into second DB2.
The structure and tablespace of both machines are same except for the DB mount file system.
Here I need to have all the data on the first machine to be replicated to second machine once in a day.
Being a newbie to Db2 the concept is very difficult for me to implement with, can I set up HADR or need to write some db2 commands to get the data from first server and populate to second server???

Could you please help me in achieving this?

Thanks,
Arun

n_i · #2 (**permalink**) 09-28-09, 12:53

Looks like a case for HADR to me.

arun26081983 · #3 (**permalink**) 09-28-09, 13:24

Hi Nick, thank you very much for the response, would you be able to help me in setting up this HADR. Being Solaris I believe there are not clients for DB2, but I have DB2 client setup on Windows machine on the same network where I have catalogued both of the Solaris servers db2 to see over the console client. now please guide me....

n_i · #4 (**permalink**) 09-28-09, 14:18

Quote:

Originally Posted by arun26081983

now please guide me....

Certainly. Where do I send the invoice?

As an alternative, you can guide yourself for free: DB2 Database for Linux, UNIX, and Windows

przytula_guy · #5 (**permalink**) 09-29-09, 05:30

this is all you need to know :
DB2 High Availability Disaster Recovery (HADR) commands
the rest is self explanatory

przytula_guy · #6 (**permalink**) 09-29-09, 05:30

this is all you need to know :
DB2 High Availability Disaster Recovery (HADR) commands
the rest is self explanatory

arun26081983 · #7 (**permalink**) 09-29-09, 11:13

Looks like need to buy HADR license for this, which might take time for the process. So is it possible anyway using db2 commands/scripts though I know that it would not be efficient? objective is to synchronize once in a day not ncessarily immediately, so any ways?

db2girl · #8 (**permalink**) 09-29-09, 11:41

log shipping is something you may consider:
DB2 Database for Linux, UNIX, and Windows
The Basics of DB2 Log Shipping

Marcus_A · #9 (**permalink**) 09-29-09, 15:53

Quote:

Originally Posted by arun26081983

Looks like need to buy HADR license for this, which might take time for the process. So is it possible anyway using db2 commands/scripts though I know that it would not be efficient? objective is to synchronize once in a day not ncessarily immediately, so any ways?

HADR is included for free in ESE (Enterprise Server Edition), and starting with version 9.5 it is also included for free in WSE (Workgroup Server Edition).

arun26081983 · #10 (**permalink**) 09-30-09, 04:55

that sounds good but mine is DB2 V 9.1 fp 7, so I think HADR will not be included for free. I will look at the option of log shipping. meanwhile any other ways using any commands?

dr_te_z · #11 (**permalink**) 10-02-09, 07:29

HADR is great, but there is more http://www.emeraldsoft.com/download_...-datasheet.pdf

arun26081983 · #12 (**permalink**) 10-07-09, 13:27

I have attached the db2 configuration from both machines, could somebody help me in doing the log shipping for replication/synchronization of DB2 servers.

Marcus_A · #13 (**permalink**) 10-07-09, 19:04

Quote:

Originally Posted by dr_te_z

HADR is great, but there is more http://www.emeraldsoft.com/download_...-datasheet.pdf

Doesn't quite work as advertised. IBM was on the verge of buying Xkoto, but found out at the last minute that there are a bunch of SQL statements not supported.

IBM may announce other options shortly.