Re: AFI - Archive Data

[Jeff_Klipa/Harvard@xxxxxxxxxxxxxx]

The first day of each month we run a job from Machine Manager that purges
the following files :
PCP01
PCP02
PCP03
PCP04
PCP06
PCP52
PCP53
PCP56
PCP58
PCP59
PCP62
PCP65
PCP93
FIP45
We only retain 12 months of data so every month we clear the previous 13th
month's worth of data...
These are all transaction files that simply take up space once the
transactions are processed...

I'd really like to include INP95 in this list too but the auditors like to
see the details of inventory movements for at least two years back...

PS - I've never really had much confidence in any of the JBA purge/archive
routines...
There was quite a discussion on this topic and perhaps you can have some
success searching the archives for the threads...

Good luck...




Sam Smith <SSmith@centura.co.uk> on 06/26/2001 07:43:03 AM

Please respond to JBAUSERS-L@midrange.com
                                                              
                                                              
                                                              
  To:          "'JBAUSERS-L@midrange.com'"                    
               <JBAUSERS-L@midrange.com>                      
                                                              
  cc:          (bcc: Jeff Klipa/Harvard)                      
                                                              
                                                              
                                                              
  Subject      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.
+---



+---
| 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.
+---