Home > IT Answers > AS/400 > Faster File copy mechanism- Want to copy a hu...
Help

Question

  Asked: Feb 28 2008   9:45 AM GMT
  Asked by: Rsm

Faster File copy mechanism- Want to copy a huge data from one AS/400 file to another AS/400 file.


AS/400, SAVF, CPYF

I want to copy a huge data from one AS/400 file to another AS/400 file. This is copying on the same machine.
I tried a CPYF command first. It takes about 45 minutes to copy that file.
Next, I tried the SAVE to a SAVF and restore from this SAVF. It takes about 20 minutes now. I would like to know if there is any faster mechanism of copying this big data file.
This file has about 200,000,00 records(20 million).

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Feb 28 2008  9:54 PM GMT  by Philpl1jb


Latest Contributors: Gilly400



If the target file exists then indexes and journals on that file will slow the process.
Other jobs can compete for the drives and other resources.

Phil

Hi,

Do you need an exact copy of your file? In that case have you tried CRTDUPOBJ?

Regards,

Martin Gilbert.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Bvining  |   Feb 28 2008  7:32PM GMT

CRTDUPOBJ across systems? I don’t think so :-)

 

Rickmcd  |   Mar 1 2008  4:29AM GMT

Have you tried the CPYF with changing the FROMRCD to 1 instead of default *Start. If the file is keyed and you use default it will copy in Key Order if you change to 1 it will copy sequentially much faster. But 20 Nillion record depending on hardware is a huge file to do anything with,

 

Gilly400  |   Mar 2 2008  4:33PM GMT

The copy is from one AS/400 file to another - not across systems ?

 

Bvining  |   Mar 3 2008  2:45PM GMT

Sorry. For some reason I thought LPAR was in the question somewhere, but I see that it isn’t…

 

Mid11  |   Mar 3 2008  3:50PM GMT

How much of the data changes regularly?
Could you use Journaling or maybe better yet triggers on the file to write/apply changes to the copy of the file.