RE: Data Transfer -- MIDRANGE-L

Going the way of data replication software (be it home grown or purchased) is another way you could tackle the issue.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski
Sent: Thursday, September 05, 2013 10:16 AM
To: Midrange Systems Technical Discussion
Subject: RE: Data Transfer

The other option we were considering is some type of incremental backup. I'd sooner just back up whatever file changes occurred over the course of the day as opposed to backing up every record as there are some records that haven't changed in months.

Does the SAVRST function allow for incremental backups, or should we be looking at some other type of command (or 3rd party backup tools) to perform that function?

Thanks!

/b;

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, September 05, 2013 1:12 PM
To: Midrange Systems Technical Discussion
Subject: RE: Data Transfer

That's a good point Gary. However, when you have 10,000 files in your production environment you want to replicate over to development it gets a bit hairy.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

From: "Monnier, Gary" <Gary.Monnier@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 09/05/2013 12:44 PM
Subject: RE: Data Transfer
Sent by: midrange-l-bounces@xxxxxxxxxxxx

Don,

If all you are interested in is copying the data from production to development and you already have the physical and logical files on the development system try using a combination of DDM and CPYF. This approach has some advantages. First, you don't have to lock the production objects while saving objects. Second, disk space usage is reduced on both systems since you don't have to have large save files on both systems. Third, you can customize data extraction.

It is relatively easy to put together a CL program to automate the copies.

o Run DSPFD FILE(yourlib/*ALL) TYPE(*MBRLIST) OUTPUT(*OUTFILE)
FILEATR(*PF) OUTFILE(QTEMP/yourfile)
o Read through the output file in QTEMP. For each entry submit a job to copy data from production to development.
SBMJOB CMD(CALL PGM(MYPGM) PARM(&MLLIB &MLFILE &MLNAME))
JOB(&MLNAME) JOBQ(QUSRNOMAX)

MYPGM does the following.

o Creates a DDM file pointing to &MLLIB/&MLFILE(&MLNAME) on the production system.
o Runs CPYF FROMFILE(DDMFile) TOFILE(&MLLIB/&MLFILE) FROMMBR(*FIRST)
TOMBR(&MLNAME)

You can substitute MYPGM for a conversion program if the developers have a file change.

Have fun.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Wereschuk
Sent: Thursday, September 05, 2013 7:59 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Data Transfer

Hi All: I'm having a problem transferring current data from a production box to our development box. I've tried using FTP but I'm having issues with this. First I did a SAVF on the library but it seems there is a limit on the amount of data that can be transferred at a time. I believe I can change the limit but that's not my main concern. I split the save into multiple save files and only saved PFs and LFs but I still end up with approx. 100 GB of data to transfer. My problem is that in using FTP it is taking about 3 hrs. to FTP 16 GB of data. This would result in a time of almost 20 hrs. to transfer the 100 GB. Is there a faster way to do this or is using a tape backup and physically delivering it to the other machine the fastest way? I only have a window of approx. 4-5 hrs. Any and all suggestions are appreciated.

TIA

******************************************
Don Wereschuk
ISD - Programmer/Analyst
Simcoe Parts Service Inc.
Phone: 705-435-7814 Ex: 302
Fax: 705-435-5029
mailto:dwereschuk@xxxxxxxxxxxxxxx
******************************************
If I'd have done what I said I should have done, then I'd be sitting here saying I should have done what I did do.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.