If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > synchronising databases optionally

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-08-03, 08:22
lshetty lshetty is offline
Registered User
 
Join Date: Dec 2003
Posts: 1
synchronising databases optionally

I require help from database stalwarts for the issue mentioned below.

We have two database oracle and db2, MAINFRAME installed on two different systems.Online applications updates/inserts data in DB2 and updates/inserts some information in Oracle database also. But there are some native implementation, which updates data in the db2 dATABASE but they do not update any data onto the oracle database.

Now the need is we need this two database to be in sync. How do we acheive it?
If we set triggers that would be applicable for any modification/insertion on the tables in DB2 but this would also lead similar action for web based online application. The synchronisation is not required for online applications since it updates both database tables. Second constraint we cannot modify the legac/ native applications which insert data in the db2 database only.

thanks for help
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On