Re: BPCS 405 CD & Wasted Disk Space

Can you explain how you are using ROBOT to do this?

-----Original Message-----
From: Hancock, Teri <THANCOCK@accuridecorp.com>
To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
Date: Thursday, February 11, 1999 7:00 PM
Subject: RE: BPCS 405 CD & Wasted Disk Space


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

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