RE: BPCS 405 CD & Wasted Disk Space

["Hancock, Teri" <THANCOCK@xxxxxxxxxxxxxxxx>]

ROBOT will do the same kind of work for you without any programming required
on your part.  We are using ROBOT to reorganize files for deleted records.

> -----Original Message-----
> From: MacWheel99@aol.com [SMTP:MacWheel99@aol.com]
> Sent: Thursday, February 11, 1999 3: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
+---