Re: AFI - Archive Data

[DAhKow@xxxxxxxxxxxxx]

Should not FIP51 be cleared accordingly also? This is the AFI Session
Control  file.





plynch@sunflowermfg.com@midrange.com on 06/26/2001 06:49:30 PM

Please respond to JBAUSERS-L@midrange.com

Sent by:  owner-jbausers-l@midrange.com


To:   JBAUSERS-L@midrange.com
cc:
Fax to:
Subject:  Re: AFI - Archive Data



Here's what we do at Sunflower... we keep 6 months of records and SQL
delete the rest. Here's the SQL:


DELETE FROM OSL@@F3/FIP45 WHERE PDAT45 <= CYYMMDD

Substitute your files library for the OSL@@F3 library.




                    Sam Smith
                    <SSmith@centura.co.        To:
"'JBAUSERS-L@midrange.com'"
                    uk>                        <JBAUSERS-L@midrange.com>
                    Sent by:                   cc:
                    owner-jbausers-l@mi        Subject:     AFI - Archive
Data
                    drange.com


                    06/26/2001 06:43 AM
                    Please respond to
                    JBAUSERS-L






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



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