Re: AFI - Archive Data

[<lsherburn@xxxxxxxxx>]

DAhKow said
>Talking about space-saving in general, we have written a little routine
> that re-orgs all files having deleted records in libraries OSLD1F3,
> OSLGLF3, OSLPLF3, OSLSLF3. If anyone knows if this is not safe, can he/she
>pls notify us? It seems to me having read somewhere that there are JBA
>files that are linked by record number (?)


I don't think that System 21 links files by record number, but even if they
did, removing deleted records would not cause any problems since the linked
records should have been deleted as well.

I have used the dspfd command to create an outfile of all files on the
system (of course you should ignore the os/400 system files).  You can use
this file to analyze the number of deleted records in each file and re-org
only those files that have reached a certain percentage of deleted records
or particularly large files.  This could be easily automated into a schedule
that could be ran nightly, every other, weekly, or whenever time permits.
By re-orging on a regular basis (at least weekly) you can eliminate the 8
hour marathon jobs.

Lee Sherburn


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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.
+---