By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Two Way Replicaiton

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
"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

P: n/a
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

P: n/a
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.