Re: 405 CD Excess Members

Al ...

We've run into the same 32 member max when creating some new logicals in
BPCS.  I've thought about identifying all the files that have multiple
members, and then running a program once a month that deletes all the
workstation members (I know there's a couple files that have
non-workstation members, but I think our workstation naming conventions
will allow me to avoid those.)  You're right, I think, that the system will
just recreate the work station members it needs.  Anything you can think of
that wouldn't work with this approach?






MacWheel99@aol.com@midrange.com on 03/23/2001 01:07:15 AM

Please respond to BPCS-L@midrange.com

Sent by:  owner-bpcs-l@midrange.com


To:   BPCS-L@midrange.com (BPCS Users Discussion Group)
cc:

Subject:  405 CD Excess Members


From Al Macintyre

I could use a review of what the members named after work stations in
various
files are used for & what harm comes from massive excess unused ones & how
do
we locate & destroy those that we do not need any more.  Perhaps I do not
care what they are used for, I just want to figure out how to get rid of
the
ones that it is safe to get rid of.

I do have a program that lists all the BPCS Data Areas & their contents,
with
a break on 1st 2 characters & asterisks identifying any entries different
from the previous one with the same prefix.  This helps us locate work
station application combinations where a user had some kind of unresolved
mishap that perhaps MIS was oblivious to.  I have also been using this
report
to assist with identification then manual deletion of work areas on work
station addresses that do not exist any more.

Tonite I created a new logical over FOD because I nneded to be accessing
records excluding "RD" additional description & also excluding a "special
operation" scenario & I needed to be accessing this same deal against more
than one logical in the same program & I got some compile errors associated
with the new logical.  Apparently WRKMBRPDM-14 defaults to 32 members in
the
file & our FOD has 76 already & I looked at the list.

In recent months we have been replacing PCs that had 5250 emulation with
Client Access & as we did so we assigned new work station addressing
scheme,
and I am wondering if

a) any of the older logicals have some similar ceiling on how many members
they can address & what happens to the user of the member that pushes over
the limit & how can I tell where I have such potential problems.  Like some
DSPFD variant to *OUTFILE & compare member ceiling if not *NOMAX with how
many actually exist.

also when the limit is 32 say ... how does it know which is 33, how do I
know
for that matter ... I am looking at my alphabetical list of all the members
&
I can see that the *FIRST name to be assigned is beyond the first 32
alphabetically.

b) even though this stuff is empty at end of day, it must eat some disk
space
& logically we should get rid of all of those that are for work station
addresses we no longer have, have not been used in months, have zero
records

Is there some SSA clean up utility for this that I have managed to
overlook?
... I vaguely remember past discussion thread with some name like "those
pesky work station work names"

I am sure FOD is not the only file that is like this.

I know DSPFD *ALL files will help me find files that have multiple members
... in fact I have another program that lists such an *OUTFILE to help me
identify files with garbage records & I guess I could use that to flag me
which files have multiple members.

I am sure that if I wipe out excess work members, BPCS will recreate them
as
needed.

I know UPI has BPCS Lite to solve all of this kind of mess, but our
strategy
has been to LEARN by doing cleanup ourselves, as our time permits to figure
out stuff that we need to do.  I figure I am a whole lot better off in
terms
of BPCS know how thanks to going from one crisis to solve to another one.
I
do not know if Central would have been better off if we just bought a
packaged solution & did not know any of this stuff.

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