AFI - Archive Data

Hi

The FIP45 file for our live environment currently has 19,031,366 records and
we are 
looking to run the archive option for the first time in the next few days.

We have run this option over redundant JBA environments with a similar
number of records and 
we found depending on the application code selected this could take anything
from 3 to 6 hours.

The end result every time has been to clear all records from the files.  

This is a very time consuming task and we were wonder has anyone ever done a
CLRPFM on 
this file ? and if so, did they encounter any problems...

Any help would be really appreciated.

Thanks

Sam Smith
Business Analyst 
Centura Foods
01606 834103



===========================================================================
This email, its content and any files transmitted with it are confidential
and intended solely for the use of the individual(s) to whom it is
addressed.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing,
or copying of this email is strictly prohibited.
This email, its contents and any files transmitted with it have been
prepared using information believed by the author to be reliable and
accurate, but Centura Foods Ltd. makes no warranty as to accuracy or
completeness. In particular Centura Foods Ltd. does not accept
responsibility for changes made to this email or related files after it
was sent. Any opinions expressed in this email and any related documents
are those of the author and do not necessarily reflect the opinions of
Centura Foods Ltd. or its associated companies.

If you have received this email in error please notify the Centura Foods
Systems HelpDesk by telephone on +44 (0) 1606 830 737.
===========================================================================



_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
Star Internet for details on the Virus Scanning Service.
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---