Re: AFI archive purge

["Rick Allen" <rick.allen@xxxxxxxxxxx>]

We have used AFI purge utility on a semi regular basis with no ill effects
(I can't say that about all the utilities though!). My experiences thus far
are to 3.5.1 only so there may be some improvements.

I understand your issue with purging and we had the same reservations. Our
solution was to archive every 3 to 6 months and then, if necessary, backup
the previous archives to tape and delete them. We leave the minimum of 3
months on the system so that we can still return to source data if required
to investigate any problems.

As far as file reorg goes, yes, you must do this whichever process you
follow. We actually run a CL once per week over all the OSLxxF3 libraries,
and some others, that runs a reorg over all the PF's and produces a query
report of deleted records.

Trust this helps

Rick Allen




DAhKow@ibl.intnet.mu@midrange.com on 20/03/2001 17:11:37

Please respond to JBAUSERS-L@midrange.com

Sent by:  owner-jbausers-l@midrange.com  Please respond to
      JBAUSERS-L@midrange.com



To:   JBAUSERS-L@midrange.com
cc:
Subject:  Re: AFI archive purge



As our FIP45 file is growing bigger and bigger, we are considering running
the AFI purge utility for the first time. Has anyone experienced any
problems with it ?
Also, as this utlity does not provide for purging for a range of period, we
might finally use SQL to remove records from FIP45 for a certain range of
periods. According to our knowledge, we would also have to remove records
from FIP51 for the relevant period range. Would anyone know if there is any
potential danger in doing the purge this way ? Do we need to do a file
reorg after this (is this safe?) ?
Note that we do not really require having the archived sessions inquiry
facility for those records to be deleted . But before deleting we would
backup these 2 files, just in case.

Thank you in advance for your input

Regards



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