473,322 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

howto keep two db2 in sync ?

Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover...
The two nodes are perfectly identical (same os, users, and db2 setup
(instances, db, tables...)).

[DB2_node1] <---- Common Virtual IP Addr ----> [DB2_node2]
MASTER (working) BACKUP (standby)
I know nearly nothing about db2 internals...

The only way I know to keep them in sync is to stop db2 on both nodes,
then run rsync on instances, fenced and admin home directories... then
restart db2.

Is it enough to keep nodes in sync ?
Is there a risk of data corruption ?
I know I should use some smart realtime replication, using db2 internals
and so on, but I can't afford working on this direction :(

Bye,
Mat.
Nov 12 '05 #1
2 6315
Ian
M.L. wrote:
Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover...
The two nodes are perfectly identical (same os, users, and db2 setup
(instances, db, tables...)).

[DB2_node1] <---- Common Virtual IP Addr ----> [DB2_node2]
MASTER (working) BACKUP (standby)
I know nearly nothing about db2 internals...

The only way I know to keep them in sync is to stop db2 on both nodes,
then run rsync on instances, fenced and admin home directories... then
restart db2.

Is it enough to keep nodes in sync ?
Is there a risk of data corruption ?
This is not supported by IBM, although it will work until someone
changes the physical database configuration and moves something
out of the instance owner home directory.
I know I should use some smart realtime replication, using db2 internals
and so on, but I can't afford working on this direction :(


There are lots of options,

DB2 Replication
Standby database using Log Shipping
HADR (new in Stinger)
Hardware HA (using Sun Cluster / Veritas Cluster / HACMP / etc.)
Probably the easiest is #2 (log shipping). There are some articles on
this at the DB2 Developer Domain.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
There are multiple options for this - log shipping, replication or HADR
which in new in FP7.

HADR would be the best way to keep 2 DB2 databases in sync. When used with
the new client re-route it will minimise any possible downtime.

Cheers,

"M.L." <m.l@no_sP_am_oceanfree.net> wrote in message
news:ch**********@news-reader2.wanadoo.fr...
Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover...
The two nodes are perfectly identical (same os, users, and db2 setup
(instances, db, tables...)).

[DB2_node1] <---- Common Virtual IP Addr ----> [DB2_node2]
MASTER (working) BACKUP (standby)
I know nearly nothing about db2 internals...

The only way I know to keep them in sync is to stop db2 on both nodes,
then run rsync on instances, fenced and admin home directories... then
restart db2.

Is it enough to keep nodes in sync ?
Is there a risk of data corruption ?
I know I should use some smart realtime replication, using db2 internals
and so on, but I can't afford working on this direction :(

Bye,
Mat.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Josef Sachs | last post by:
Is Andrew Kuchling's regex-to-re HOWTO available anywhere? I've found the following (dead) links on various Web pages: http://py-howto.sourceforge.net/regex-to-re/regex-to-re.html...
2
by: ~K | last post by:
I have 3 Oracle servers that I would like to keep in sync. Only one is used as my production, the other is a backup and the third is used for development purposes. In case my primary Oracle server...
1
by: kartik | last post by:
I open an fstream in read-only mode, read till the end, then try to sync() before seeking to position 0 & reading again. But the sync fails. I discovered that clear()ing the stream before the sync...
5
by: alejandro lapeyre | last post by:
How can I load / parse an HTML file with .NET? Thanks! Best regards, Alejandro Lapeyre
1
by: cppdev | last post by:
Hello, After reading a few articles, http://blogs.gotdotnet.com/cbrumme/PermaLink.aspx/e55664b4-6471-48b9-b360-f0fa27ab6cc0...
5
by: Rob | last post by:
I have a form where the user may see a matrix of data in a grid (populated via a dataset). If the user wishes to add a new row of data, they click a button and a new form opens where the user may...
2
by: Anthony Malt | last post by:
Hi, my server has a database table. I read this table on the server into a dataset and my client retrieves it through a webservice. No changes on the client and server happen. What's the best...
13
by: Ben Voigt [C++ MVP] | last post by:
This is more of a C# question than a C++ question, but my best chance of explaining it is via comparison to C++. Ok: In C++ you can forward declare a type. Then references to that type can be...
0
by: glubber | last post by:
I have a cronned perl script that runs on a different server. when I try to restore it to the server below things dont copy across correctly. the target server is described below. debian 4.0...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.