Refresh data from one AS/400 to another

370 pts.
Tags:
AS/400
Development Servers
Production Servers
We have a production AS400 for our users and a test AS400 for our developers and we would like the data to match. Is there a way to refresh the data from the production box to the test box?

Answer Wiki

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

Hi,

Check whether Data Transfer utility is present in ur application. Using that, you can copy the Data from Production, Pseudo-production, and QA to Test environment. You can select the PolicY #, Product and Division.

Discuss This Question: 10  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.
  • Gilly400
    Hi, You should be able to use SAVRSTOBJ or SAVRSTLIB to save and restore between the 2 machines. Once you've done this once to get everything synchronized, you should be able to use SAVCHGOBJ to save to a save file to get your production changes and send the save file to your development machine. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • wpoulin
    Jean43, Another option; We have the same situation, but create save files of our production environment then thru FTP transfer the save files to our development system and then use rstobj and rstlib. I would be willing to share the code if you're interested. Hope this helps, Bill Poulin
    2,480 pointsBadges:
    report
  • Jean43
    Gilly400 - would the SAVRSTOBJ or SAVRSTLIB work if we're using BRMS? I'm new to BRMS and don't know anything about it. Thanks.
    370 pointsBadges:
    report
  • Jean43
    Wpoulin - Sure, I'd like the code if you're willing. Please send to jean.lynch@lactalis.us. Thanks.
    370 pointsBadges:
    report
  • Gilly400
    Hi, The SAVRST* commands work outside of BRMS - you don't need BRMS to use them. BRMS shouldn't have any effect on them. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • ejaaje
    Hi, anyone still doing the DB refresh here? please i need a proper steps.as I m very new to this. thanks. 
    140 pointsBadges:
    report
  • ToddN2000
    If the machines are located in the same facility you can always do a backup and restore. That's the easiest solution.  Another method we use here is that we have a program set to copy over key data files ,the ones that change constantly. Files like the order header, order detail, A/R, A/P, purchasing. For our other files like our part master we do not bother with them unless requested. Then we run this job on the weekend to refresh the test environment. With a copy of the files from the PRODLIB to the TESTLIB.  We monitor if the file is in use for some reason and if so , skip to the next file.
    CPYF       FROMFILE(PRODLIB/ORDERS) TOFILE(TESTLIB/ORDERS)
               MBROPT(*REPLACE)                               
                 /* CHECK IF IN USE */                                 
    MONMSG     MSGID(CPF2909) EXEC(GOTO CMDLBL(BU_FILE2))    
    MONMSG     MSGID(CPC2955) EXEC(GOTO CMDLBL(BU_FILE2)) 
    45,650 pointsBadges:
    report
  • ejaaje
    hi toddn2000,
    thanks.. yes, we also perform backup and restore on the test machine.but,after that we hv another steps. 
    we need to end journal,delete,disable triggers,n then need to rename orig library to two diff names.next start journaling to newly named libraries,grant objaut. and we also hv another steps to update the tables using SQL statements. does the step you mention covers all of what we hv been doing here? or anyone have complete steps? thanks.
    140 pointsBadges:
    report
  • ToddN2000
    Sounds like your process is a lot more involved that a simple restore or simple CPYF would resolve. I have not worked with journaling so I'm limited there. You also say you "need to rename orig library to two diff names".. How are you renaming to 2 different names ?
    45,650 pointsBadges:
    report
  • ejaaje
    Todd, yes it is. We restored twice and it takes a long time because that library sized 1.5TB. That's why I'm asking if there is anyone here do have the same situation like mine. We need to perform entire backup prior to db refresh. Both prod and test are located in two different locations.
    140 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.

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

Following

Share this item with your network: