BPCS 405 CD & Wasted Disk Space

Our AS/436 has been running BPCS 405 CD since August 1998, but we are new to
OS/400 and have much to learn.  One recent discovery was that OS/400 re-uses
deleted space only if the files are setup with REUSEDLT(*YES) and not all BPCS
files are setup that way, so we managed to accumulate a few million deleted
records that were just eating disk space since we went live on 405 CD.  I
recently shared this story on the Midrange Forum devoted to AS/400 Application
Packages, where there is a thread about BPCS, and a couple of other visitors
there posted some very high caliber information talking about what we could do
about the problem.  

Thanks to their guidance, I created a CL that sends DSPFD *ALL files *ALL
libraries for FILEATR(*PF) TYPE(*MBR) to work file OUTFILE(XFILES/QAFDMBRL)
OUTMBR(QAFDMBRL) then use query with record format QWHFDMBR to select only
those statistics that have deleted records MBNDTR GT 0 sorting wasted disk
space MBNDTR * MBMXRL so the worst cases are on top of the list, to help us 
prioritize which gets RGZPFM, then delete work file.  I now run this regularly
& plan a CL to automate fixes of the worst repeating offenders.  Check the
forum for step by step instructions how to do this, if your learning curve is
similar to ours.

I have been finding deleted records in a lot of places I did not expect to
find any, such as some files in SSA's PTF-1 which were apparently delivered
with more deleted records than good records & have been that way for months &
us oblivious to it.

Hoping my first posting to BPCS-L has been constructive

Regards

Al Macintyre
MIS Manager / Programmer at Central Industries in Evansville Indiana
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---