|
Make sure you remove all indexes from at least the target PF before you do the copy. If the indexes are there, then the system is going to try to rebuild each index over each logical file over each record you add.... a tremendous resource hog and one which can literally add days to a large copy. Remove all indexes/logicals first and then do the copy and then do rebuild them again. -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski Sent: Sunday, November 06, 2005 8:51 AM To: Midrange Systems Technical Discussion Subject: Copying Large PF Files - Quickest Way? Hi All, What is the quickest way to copy a PF from one source to another? I have two physical files that are about 2.5 - 3.5 million records that I would like to copy. However, if I do the standard cpyf command, it takes hours to copy the files. Is there any easy (and quick!) way to do this operation that won't tie up my server (and my time) for hours? Thanks! Brian. -=-=-=-=-=-=-=-=-=-=-=-=-=- Brian Piotrowski Specialist - I.T. Simcoe Parts Service, Inc. PH: 705-435-7814 FX: 705-435-6746 -=-=-=-=-=-=-=-=-=-=-=-=-=-
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.