RE: BPCS 405 CD & Wasted Disk Space

My company sells a software product that will simplify the purging,
archiving and reorg processes, especially for BPCS users.  One of the
utilities included with the packages is similar to the program you
described.  In addition, it will purge files as easily as writing a query
(without locking files), it will add the archiving feature to an existing
purge program without programming, and it supports archives to tape.  If you
are interested, please check out http://www.arctools.com .

-----Original Message-----
From:   owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com] On Behalf
Of
Sent:   Thursday, February 11, 1999 4:24 PM
To:     BPCS-L@midrange.com
Cc:     Al Macintyre
Subject:        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
+---

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