Re: Purging BPCS Files of Items not in IIM -- BPCS-L

Right Al,
 or you can buy our Archiving software which does it all for you and makes
sure no files are left out of synch. We worked for SSA for many years, and
so we know how the files are put together.

And it's not just a question of disk space - archiving or not directly
affects response times and performance. Your users will be really happy
after you have archived, and especially because with our software they can
still inquire on the archived data!

For details e-mail me offline, or see our website.

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
www.smallblue.co.uk
Phone +44 1223 277657
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>
To: <bpcs-l@midrange.com>
Sent: Wednesday, September 18, 2002 9:05 PM
Subject: Re: Purging BPCS Files of Items not in IIM


>
> >We have BPCS files that contain records that have no matching Item in the
> >Item Master (IIM) file.  Is it safe to delete these items from other BPCS
> >files without any kind of verification?  Thanks for the advice in
advance!
>
> This is something I been working on, and not just IIM file.
> You need to be familiar enough with BPCS of your version to see what is
> going on, like notes files with pointers to originals that aint there any
more.
> In my case, cleaning out IIM file is the LAST file I hit after cleaning
out
> stuff that affects costs and planning for example, then the actual cost
> planning files.
> I not clean out the records if there been ANY activity on them recently.
> You also have to be careful with new records ... a new record can show
date
> of last activity being NONE, so different dates used to eliminate from
> confusion.
>
> BPCS is good at adding records for a growing business.
> It is not good for handling turn-over of business where there are
> engineering changes, model line changes, turn over of customers.
> Some files purge themselves more or less automatically within the course
of
> monthly and annual operations, while others accumulate data to infinity.
> I wrote a program to take an IBM dump of 400 file statistics then look at
> each file with SQL to get the oldest date there, and put the whole thing
in
> chart format so we could see .... Ok if we eliminate all the records more
> than 2 years old from this file we will save X disk space, so now I have a
> bunch of tiny programs we run annual or more often to do that with various
> files.
> This was after I had a chat with each department ... how long do you need
> to keep shipping history ESH ESL records anyway, or whatever the case may
be.
> My analysis found there was more disk space wasted from duplicate software
> than from dead records in the files.
> You can get the whole package written for you from some consultant.
> Go to the UPI web site and check out BPCS LITE
> http://www.unbeatenpathintl.com/bellslite.html
>
>
> -
> Al Macintyre (macwheel99@sigecom.net via Eudora)
> Al's diary http://radio.weblogs.com/0107846/
> Cure cancer. http://members.ud.com/about/
>
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>