RATE THIS ANSWER
0
Click to Vote:
- 0
0
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.
Vision Solutions owns the big three solutions. www.visionsolutions.com
1. iTera Echo2 - Light and used to be very cheap
2. Lakeview MIMIX - They have something for everyone and is very easy to use
3. Vision OMS - Large scale and expensive
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.
DataPropagator, System i, DB2 universal database
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 
