How to mirror two databases (PRD to DEV)?

385 pts.
Tags:
AS/400
AS/400 development
AS/400 FTP
Backup to Disk
Data
Database mirroring
IBM iSeries
HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks

Answer Wiki

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

The AS400 has remote journal capabilities that manage this type of process.
But you might as well buy a D.R./H.A. package from Vision Solutions. It’ll be cheaper and faster.

It might help you to look at only saving the changed objects. SAVCHGOBJ
Perhaps you find that many of the files you’re saving don’t change very often. Saving the changed objects would make your FTP transmissions shorter most of the time.

You’ll need to keep track of the date/time that you run the SAVCHGOBJ command for.

Alternately, you could look into putting your production database on external storage that supports LUN cloning. You would flush the memory to disk and suspend writes, initiate a clone of the production LUN, once the clone finished, resume writes. At that point you would point your dev machine to the cloned LUN and have a perfect copy that only took as long as the clone does.

Discuss This Question: 8  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
  • Lovemyi
    Another way to mirror is using the journals and creating your own mirroring software. There is an IBM Redpiece by Larry Youngren on the IBM Redbook website called something like "Mirroring on a Shoestring". In it he shows you how to restore the journal on a backup machine when the journals normally will not restore on a different machine. There is a trick that once you see it does not seem hard at all. This mirroring technique is basic but just to mirror a few data libraries, it will do the trick. I sat in on one of his sessions at Common on this topic and I can tell you from working with all the other 3rd party mirroring software out on the market that this is just the solution for a situation like yours. Good hunting Lovemyi
    2,310 pointsBadges:
    report
  • Tpinky
    Another way is OptiConnect if you have it available on your system. ObjectConnect is an i5/OS licensed program that enables automated object distribution between any System i, iSeries, and AS/400 machines. Packaged as product option 22 under the i5/OS operating system (5722SS1), ObjectConnect is available in all recent and prior versions of i5/OS and OS/400, going all the way back to OS/400 V3R1M0. See this link for more information... http://www.itjungle.com/fhg/fhg031208-story03.html
    4,165 pointsBadges:
    report
  • Rockleadme
    Thanks Guys.!!! I did find that some thing from Vision solution installed on my system - OMS400. Object mirrorring system - this used to replicate the live data on to disaster server. DR is not my area so i was not aware of it. We have a thing with the ops team :-) Now i will try to use OMS to mirror data on to my DEV box (hopefully without the help of ops team). Any body has any link or anything that might help me get started.
    385 pointsBadges:
    report
  • Rockleadme
    is OMS400(ODS400) has something to do with MIMX-HA or ORION?
    385 pointsBadges:
    report
  • slack400
    OMS sounds like Orion. There's some configuration and possible licensing issues that you'll run into if you want to replicate to your Dev box. With this type of process you'll probably want to suspend replication and make a copy of the library on your dev box and use that one for testing. The self healing processes of these software packages will tend to repair any changes your made to the data and that may interfere with your testing.
    2,705 pointsBadges:
    report
  • Lovemyi
    OMS400 must be Orion because MIMIX uses libraries MIMX and LAKEVIEW.
    2,310 pointsBadges:
    report
  • Rockleadme
    thanks, inputs much appreciated.
    385 pointsBadges:
    report
  • mcl
    We've been running Vision's OMS400 and ODS400 for about three years for our DR system. It works great. It uses remote journals to handle transfer of data and objects from a source to a target system. They are part of Orion. OMS400 - Mirrors data ODS400 - Mirrors Objects Objects can include anything - programs, user profiles, out queues, etc. Prior to installing Vision we developed a "replication" system to pull data from multi-member databases to one central database. We actually still use it. If you are going to use Vision to replicate data from PROD to DEV you will probably need to upgrade your licence ($$$) for Vision software on your DEV system - unless you already have it installed on DEV. On the plus side, you already have journaling going for DR, you can "piggyback" on the with remote journals to your DEV system and develop your own software. You're ops team will likely need to help you with setting up the journals. And it does work - we are journaling from our PROD box to both the DEV and DR boxes. One last thing - Journal receivers - Vision manages them for you - but if you have your own software you'll need to manage them. They can chew up DASD. Regards Mike
    2,740 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