Two Way Replicaiton

[Mark]

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?

[Fan Ruo Xin]

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?

[Mark]

"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.

[Knut Stolze]

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

[Ford Desperado]

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?