Re: AS400 V4R4 File Sizes Needed, Please Help... -- BPCS-L

Hi,
    We also had a problem with our BPCSF file getting larger. I started
running the following to keep track of sizes.

    Run DSPFD for *ALL files in BPCSF.
    The type of info is *MBRLIST.
    I put it out to *OUTFILE
    File attributes is *PF

I then run two queries. One will list all the files, # of members, # of
records, deleted records & size.

I then run another query to compare the first file I created like this to
the one I ran this week. I print any files that are + or - 5% of the
original file. It gives a good idea of what is growing, without looking at
all the files.

Terri Harteau
tshaw@felkerbrothers.com
Felker Brothers Corp.
----------------------------------------------------------------------------
--------------------------------------
Whoever said nothing is impossible never tried slamming a revolving door.
----------------------------------------------------------------------------
--------------------------------------
----- Original Message -----
From: <MacWheel99@aol.com>
To: <MIDRANGE-L@midrange.com>; BPCS Users Discussion Group
<BPCS-L@midrange.com>
Sent: Friday, May 25, 2001 10:51 AM
Subject: Re: AS400 V4R4 File Sizes Needed, Please Help...


> I suggest you repost this to BPCS_L since there are many native BPCS tools
to
> solve much of what you need, and many many BPCS_L people who can give you
> specific 400 code needed to fill the gaps.
>
> > From: Forwiw@aol.com
>
> (on Midrange_L)
>
> >         Hello All,
> >
> >   Is there a way to list all the files and file sizes in a given
library?
>
> DSPLIB F4 specify library such as where most of our BPCS files are
located,
> and there are ways to limit what is displayed, to exclude program
artifacts &
> you end up with a nice chart listing the files & their gross sizes.  This
> sort of data can also go to an *OUTFILE ... we have this in IBM scheduler
to
> run a report regularly that shows # records coded for deletion times size
of
> file equals disk space that can be recovered via reorg, sorted so the most
> needed for reorg is at top of list.
>
> >  I tried the DSPFD with *outfile but the file size is not available.
>
> You need to do F4 & try out the different combinations.
> File Size is available - but you have to hit the right combination.
>
> >  The reason I need this is I would like to know, in descending order,
> >  what files are taking up the most room in our production library.
> > Then I can determine what needs to get done with these files, purge,
> >  etc.
> >
> >               We are running BPCS version 6.01.01 Mixed Mode.
> >
> >               Any help, will be greatly appreciated.
> >
> >               SS
> >               In BPCS Land
>
> I suggest you repost this to BPCS_L & check the BPCS archives.
>
> http://archive.midrange.com/bpcs-l/index.htm
>
> There has been A LOT OF TRAFFIC with respect to variations on this topic.
>
> There is a BPCS option - SYS menu/23 to reorg menu/12 (run it when no one
> else on BPCS) which reorgs 99% of the BPCS files to get rid of both hard &
> soft deleted records.  It also makes performance superior for programs
that
> are accessing the files that got reorged.
>
> There are check lsits that have been shared via BPCS archives.
> What stuff should be run monthly, weekly, etc. to get rid of unwanted
> records, such as inventory work areas that have zero on hand & have had
zero
> activity for months.  This excess can build up a lot of glut cluttering
> visibility & access to what is in fact active.
>
> There are rules for how long to retain certain records & 3rd party systems
> that work with BPCS to improve the archiving capabilities.
>
> There is also disk space wasted with excessive numbers of members & data
work
> areas ... we had files with in excess of 500 members that are all empty.
You
> have to know what to look for.
>
> Don't forget about BPCS LITE at
> http://www.unbeatenpathintl.com/services.html
>
> Cleaning up BPCS wasted space can be a full time job.
> Or, you can buy some software that finds it for you.
>
> When you install BPCS, it creates thousands of files, but depending on
your
> system parameter settings & application combinations being used, you might
> only have need for a fraction of those files that were created.  Even
though
> those files have zero contents, thousands of empty files do not take up
zero
> space on your 400, and can be a distraction.
>
> I have had end users come to me with a problem with a query/400 not giving
> them the expected results, because they looked at the list of files, found
> one that seemed relevant & unbeknownst to them it was one of the empty
files
> that BPCS adds to our collection to make life interesting - the user
probably
> expended many hours on this before coming to ask me for help.
>
> But which of these files that are now empty are in fact work files in some
> process that we do need to keep?
>
> You can research this yourself, of buy BPCS LITE from an outfit that has
done
> the research work.  I have been unable to persuade my management to buy
BPCS
> LITE, so I have been nibbling on reinventing what they already know.
>
> MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
> AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax
> interactive & batch) @ http://www.cen-elec.com Central Industries of
> Indiana--->Quality manufacturer of wire harnesses and electrical
> sub-assemblies - fax # 812-424-6838
>
> +---
> | 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
+---