Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replicating data between different remote databases in realtime

Status
Not open for further replies.
RoryMoynihan

RoryMoynihan

Programmer
Oct 7, 2003
3
GB
Hi,

I have two enterprise applications. The existing app connects to an existing schema. This schema is a linear design. We have a new object-oriented application connected to a relational model designed to reflect our object model, which is new. Both apps will, for now, continue reading and updating there relevant db's. These apps both do the same thing from a users perspective but in different ways.
We need each db to provide a single view of all the data captured by each app by replicating data between each db. We can't use triggers as this will create an infinite loop (16 iterations). Has anyone encountered this problem and if so what was the solution?
 
Sort by date Sort by votes
Rory,

I have used Data Propogator Relational (DPROPR) extensively for similar situations. Used properly it is very nearly real time.

There is already some good info on DPROPR within this forum, if you use the search facility. Post again if you don't find what you're looking for.

Cheers
Greg
 
Upvote 0 Downvote
Greg,

Thanks for that but I can only find one post about disaster recovery for DPROPR. Could you point me to a more specific thread please.

Also, is this the only way that this can be done - by using another application?
 
Upvote 0 Downvote
Rory,

The only way I know is using some of the db2 add ons. Take a look at the following link and see if anything in there does the trick for you.


I was unable to find anything regards the DPROPR family in the forum to. It must have been archived. Found the following on google


everything else seems to have disappeared into the ether.


Thanks
Greg
 
Upvote 0 Downvote
Thanks Greg for your help. I don't think I will be able to find a simple solution, but DRDA seems like something I should investigate
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
250
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
303
walter.weinmann
walter.weinmann
Pauljohn44
  • Locked
  • Question
Pivot data with two key fields
Replies
0
Views
156
Pauljohn44
Pauljohn44
gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
346
gdg1976
gdg1976
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
172
gdg1976
gdg1976

Part and Inventory Search

Sponsor

Back
Top