471,896 Members | 1,782 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Two Way Replicaiton

Is it possbile to replicate two ways to keep two tables in sync, where
inserts, updates and deltes may applied to each table by different
applicaiton programs? Or would this cause a continous loop?
Nov 12 '05 #1
4 1182
Do you mean if you defined table A in db-a, and table B in db-b, then any
change to table A will be synced to table B, at the same time, any update of
table B is also copied to table A?

"Mark" <m0****@yahoo.com> wrote in message
news:a5**************************@posting.google.c om...
Is it possbile to replicate two ways to keep two tables in sync, where
inserts, updates and deltes may applied to each table by different
applicaiton programs? Or would this cause a continous loop?

Nov 12 '05 #2
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message news:<Dl*****************@newssvr17.news.prodigy.c om>...
Do you mean if you defined table A in db-a, and table B in db-b, then any
change to table A will be synced to table B, at the same time, any update of
table B is also copied to table A?

Yes.
Nov 12 '05 #3
Mark wrote:
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message
news:<Dl*****************@newssvr17.news.prodigy.c om>...
Do you mean if you defined table A in db-a, and table B in db-b, then any
change to table A will be synced to table B, at the same time, any update
of table B is also copied to table A?

Yes.


Yes, that's supported by DB2 replication.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #4
Knut Stolze <st****@de.ibm.com> wrote in message news:<cl**********@fsuj29.rz.uni-jena.de>...
Mark wrote:
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message
news:<Dl*****************@newssvr17.news.prodigy.c om>...
Do you mean if you defined table A in db-a, and table B in db-b, then any
change to table A will be synced to table B, at the same time, any update
of table B is also copied to table A?

Yes.


Yes, that's supported by DB2 replication.

what happens if there is an atempt to modify one and the same row on
both databases simultaneously, by 2 different users?
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Damien | last post: by
6 posts views Thread by jai | last post: by
13 posts views Thread by m0002a | last post: by
16 posts views Thread by John | last post: by
reply views Thread by YellowAndGreen | last post: by

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.