467,926 Members | 1,414 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

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
  • viewed: 1115
Share:
4 Replies
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
By using this site, you agree to our Privacy Policy and Terms of Use.