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.
2  6225 
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! =-----
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
by: alejandro lapeyre |
last post by:
How can I load / parse an HTML file with .NET?
Thanks!
Best regards,
Alejandro Lapeyre
|
by: cppdev |
last post by:
Hello,
After reading a few articles,
http://blogs.gotdotnet.com/cbrumme/PermaLink.aspx/e55664b4-6471-48b9-b360-f0fa27ab6cc0...
|
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...
|
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...
|
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...
|
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...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: AndyPSV |
last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
|
by: Oralloy |
last post by:
Hello Folks,
I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA.
My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
|
by: Ricardo de Mila |
last post by:
Dear people, good afternoon...
I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control.
Than I need to discover what...
|
by: Johno34 |
last post by:
I have this click event on my form. It speaks to a Datasheet Subform
Private Sub Command260_Click()
Dim r As DAO.Recordset
Set r = Form_frmABCD.Form.RecordsetClone
r.MoveFirst
Do
If...
|
by: ezappsrUS |
last post by:
Hi,
I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
| |
