× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: AS400 V4R4 File Sizes Needed, Please Help...
  • From: "Randy S. Merle" <rmerle@xxxxxxxxxxxxxxx>
  • Date: Fri, 25 May 2001 13:14:59 -0500


The following DSPFD command:

===> DSPFD FILE(CHGORDHST/*ALL) TYPE(*MBRLIST) OUTPUT(*OUTFILE)
OUTFILE(QTEMP/TEST)

Gives you the following information:

 Seq  Field                   File               Text
      MLRCEN                  TEST               Retrieval century:
0=19xx,
      MLRDAT                  TEST               Retrieval date:
year/month/
      MLRTIM             TEST               Retrieval time: hour/minute
      MLFILE                  TEST               File
      MLLIB                   TEST               Library
      MLFTYP                  TEST               P=PF, L=LF, R=DDM PF,
S=DDM
      MLFILA                  TEST               File attribute: *PHY or
*LG
      MLMXD                   TEST               Reserved
      MLFATR                  TEST               File attribute:  PF, LF,
PF
      MLSYSN                  TEST               System Name (Source
System,
      MLASP              TEST               Auxiliary storage pool ID:
      MLRES                   TEST               Reserved
      MLNOMB             TEST               Number of members
      MLNAME                  TEST               Member
      MLNRCD                  TEST           Current number of records
     MLNDTR              TEST           Number of deleted records
      MLSIZE                  TEST           Data space and index size i
      MLSEU                   TEST               Source type for S/38 View
a
      MLCCEN                  TEST               Member creation century: 0
=
      MLCDAT                  TEST               Member creation date:
year/
      MLCHGC                  TEST               Last change century:
0=19xx
      MLCHGD                  TEST               Last change date:
year/mont
      MLCHGT                  TEST               Last change time:
hour/minu
      MLMTXT                  TEST               Text 'description'
      MLSEU2                  TEST               Source type
      MLUCEN                  TEST               Last Used Century: 0=19xx,
      MLUDAT                  TEST               Last Used Date:
year/month/
      MLUCNT                  TEST               Days Used Count

This is one way to get your data.

Randy Merle, Project Executive
Crowe, Chizek and Company, LLP
Direct:  (317) 706 - 2614
Cell:      (317) 752 - 5260
Fax:      (317) 706 - 2660


                                                                                
                                     
                    MacWheel99@aol.                                             
                                     
                    com                    To:     MIDRANGE-L@midrange.com, 
BPCS-L@midrange.com (BPCS Users          
                    Sent by:               Discussion Group)                    
                                     
                    owner-bpcs-l@mi        cc:                                  
                                     
                    drange.com             Subject:     Re: AS400 V4R4 File 
Sizes Needed, Please Help...             
                                                                                
                                     
                                                                                
                                     
                    05/25/2001                                                  
                                     
                    10:51 AM                                                    
                                     
                    Please respond                                              
                                     
                    to BPCS-L                                                   
                                     
                                                                                
                                     
                                                                                
                                     



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.