Re: "Remove BPCS File Members" (SYS124)

Thanks Tom,
for your observant question which jogged Clare's memory and gave me
something to try out.

I did try this in test environment with CHGJOB LOGCLPGM(*YES) to help me
try to track what it doing ... it clearing members of files, not touching
data areas.

The screen interface is very similar to SYS120 which I run weekly to clear
BPCS files of deleted records, when nothing else on BPCS: F6 WAIT F18 F6 F6

However, it is non-obvious if there is a compound command to get rid of
100% of those pesky work station members that are
(a) empty
(b) not needed

I used 5 to view lists of members then used my knowledge of application
naming conventions since the screen did not show which members actually
populated.

We want to keep
*ALL *FIRST where member name match file name
AP* LOG
EC* QUOTE RETURN
FLT WORK BACKFLUSH
but it was tedious to populate screens of all other members with get rid of
them

We got audit trail confirming what members got deleted

Given high volume of files not needing any such cleanup, it helps to know
how to identify those that do need cleanup, so we not even mess with the
others.

DSPFD *MBRLIST to *OUTFILE then Query/400 found files with most excess
members for us =

KEB
ESN
FSO
FMA
FOD
ESR
BBH
BBL
EWS
ECL
BIP
GJWD
PDT
ECH
ECS
KAO
KFP
KPR
RAR
Q*SRC (be careful here - this is source for file updates - BMRs & mods)
ESCX and CHGRSM (our modifications)

As for members named after work station identities that are no longer
needed, I found it useful to DSPOBJD OBJTYPE(*DEVD) DETAIL(*BASIC) to an
*OUTFILE then sort on date last used, to see those still in use.

Hello there,

I remember we (SSA) did have a programmer who wrote a solution for the
problem of excess file members (wsids and users that no longer exist on the
system etc), and I believe this option is it, however maybe you could test
it first on a test environment !

cheers,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
web: www.smallblue.co.uk
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@btinternet.com
Mobile: +44 (0)7960 665958

----- Original Message -----
From: "Al Mac" <macwheel99@sigecom.net>

> Unfortunately, I have no idea what the option does, but I shall eagerly
> await other posts to this thread, to see if you have found an answer to
> what many of us desire.  From perspective of wasting 400 resources, these
> empty members are not a disk space problem (I have been working on what IS
> a disk space problem) but I suspect might contribute to performance
issues,
> and I had occasion to add a new logical to a file that had over 200 of
> these excess members, but OS/400 error messages informed me that only 32
> could be attached to my new logical.  An extra hassle I did not need.
>
> 1. Check the BPCS_L archives ... there was a discussion Spring 2001 of the
> topic of excess members involving me and Lisa Abney in which Roger Wolf
> shared the actual program code used at his company to get rid of unwanted
> ones.  If you cannot find this (some of it might have been off list), I
> have cut & paste of the entire thread that I can send you a copy of (far
> too long to repost to the list) because implementing this is in a huge
pile
> of things I need to do some time but have not in fact carried out.
>
> Perhaps with Roger's permission the solution code could be posted to some
> web site like www.midrange.com BPCS/400 FAQ or connected to my
> http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
>
> 2. Visit the UPI site and check out BPCS LITE.
> http://www.unbeatenpathintl.com/bellslite.html
>
> 3. I would not mind knowing where there is a good authoritative
> documentation that explains what each and every option of SYS and SYS/23
> does, for those of us who are not on OSG ... I have constructed notes on
> many of them for my usage at work.
>
> >Greetings and Salutations!
> >
> >BPCS version 4.0.03 -- Can anyone tell me what the SYS menu option 15
> >-- Remove BPCS File Members (SYS124) does?
> >
> >I am hoping that it will remove all of the extraneous unused
> >workstation and other members that BPCS leaves lying around.  Would this
> >be correct?
> >
> >Many thanks.
> >
> >Tom Jedrzejewicz
> >IS Manager, Contessa Food Products
> >310 832 8000
> >tjedrzejewicz@contessa.com
> >--------------------

Al Macintyre
BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/
Al at home http://ryze.org/view.php?who=Al9Mac
Find BPCS Documentation Suppliers
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html