bi-directional data synchronization on System i for db2 databases

15 pts.
Tags:
DataPropagator
IBM DB2
System i
I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases. What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Data Synchronization between two System i files.

Since the System i file system is a DB2 Db then I would like to clarify that a bit at first. While you may view the Databases on the System i with the DB2 viewer and may have created them so you as the DB2 person thinks they are DBs they are nothing more than flat files or in this case files on the System i in a library. So for this example you may refer to them as DB2 Databases, I will just call them files.

The System i was built over 25 years ago before anyone was so much as thinking about databases, but the smart people in Rochester Minnesota all knew what they were up to.

If you look on the System i you will see that every thing is stored in a Library, and the then we store data in files in those library’s or LIBS. From the outside and to the non-System i eye they might look like a well run Database.

So how do we keep them in sync on two separate systems. This answer could in fact go on for days. IBM has a way yo cluster two System i servers so that you can have them both in sync. I will try to find that link and provide it. It’s rather lengthy but it will work.

There are third party applications that will help as well. I am going to offer up a link as the one place to go and figure out what type of solution you are looking for. Do you need High Avalilibility or a DR or Data Vault type solution.

I think for your money an iTera Echo2 would be the best answer but a quick call to Chris at Shield Advanced Solutions should sort all that out. He can listen to you issue and come up with a solution.

You also have *NOMAX and they offer some workable solutions for your problem as well.

IBM Offers a page on CBU and other stuff

Then there is Trader’s a company I think out of France that offers some of the same things and is very simple to use and very lite.

IBM recently purchased DataMirror and they offer iCluster as a solution. You might want to talk to them as well.

I will add the link on how to from scratch as well just using the i5/OS when I find it.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Aroyzen
    Thanks for the answer, but let me clarify on my question. We are planning to have both databases on the same system, but the new database will be DDL-defined files as oppose for the existing one being DDS and the new tables will not be a mirror of existing files. We would like to develop a custom sync solution using triggers and cross-reference files. May be you have some suggestions about that. Thanks in advance.
    15 pointsBadges:
    report
  • TomLiotta
    We would like to develop a custom sync solution using triggers and cross-reference files. I'm not clear what the question actually is. From that statement, it looks like you already know what you need to know. What's going to be interesting will be the "bi-directional" part. You'll have File1A in LibA and File1B in LibB. When File1A is updated, your xref table may say that File1B needs to be updated in a similar way. That's easy enough. But if it's "bi-directional", it would seem that you'll also want updates to File1B to be reflected in File1A, thereby potentially starting an infinite loop. Part of the trick, then, will be detecting the source of the updates. If they're coming out of a trigger in the other database, you don't want to reflect those updates back in the other direction. Did you settle on a method? Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following