Re: Data Purging

Would you consider sharing your code ?

Regards,
Sean McGovern 

-----Original Message-----
From: bpcs-l-bounces+sean.mcgovern=emea.tycohealthcare.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+sean.mcgovern=emea.tycohealthcare.com@xxxxxxxxxxx
m] On Behalf Of Molyneux, Tom
Sent: 12 February 2007 09:22
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Data Purging

We are on V6.04. Some time ago we had problems, not so much with disk
usage as the fact that, if left to it's own devices, BPCS builds up data
at a staggering rate of knots and standard tasks begin to take ages to
complete as programs plough their way through millions of records.

To alleviate this and before I knew what archiving tools were available,
I wrote some programs of my own to take data off live BPCS files and put
them onto archive files that could still be accessed by in-house
enquiries and reports and retrieved back to the Live system in case of
problems. From there it would be a short step to actually deleting data
to make disk space.

I archive the following data :

Customer Orders : ECH, ECL, ECS and ESN

Shop Orders : FSO, FMA, FOD, FLT and ESN

Purchase Orders : HPH, HPO and ESN

Pick List Pribt File : IPP

Print Detail Work File : ZPD

Material Requirements File : KMR

Inventory Transaction History File : ITH

Promotions & Deaks Master File : PDM

Special Prices File : ESP

Cost Master File : CMF

You need to carefully determine your criteria to make sure you don't
archive/delete anything you need.

After consultation with our Accounts Department, we also archived some
old years off the G/L files - eg GLH, GHH, GSB - that were completed and
this took off millions of records. 

So, if you can find software that does the job for you - great. But if
not, there are ways of doing it yourself.

Tom Molyneux

-----Original Message-----
From: bpcs-l-bounces+tmolyneux=mono-pumps.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+tmolyneux=mono-pumps.com@xxxxxxxxxxxx] On Behalf
Of Al Mac
Sent: 09 February 2007 04:35
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Data Purging

   I wanted LOCKSMITH, because it works for ALL files, then we could
decide
   what to purge from there, but company profit margin too low to
support
   add-on software I thought we needed for improving productivity (not
just
   LOCKSMITH), so I had to develop a series of programs to
     * Identify BOM & Routings for parts we have not needed in X years
     * How old is data in various files, then programs to get rid of
stuff
       older than something people can agree to ... like 2 years  ...
stick
       in the scheduler to send reminder message to me every 3-4 months
that
       it is about time to kill the oldest data in whatever file set,
and
       remind me name of program to do that ... documentation in that
program
       includes what the checks & balances are to make sure it goes
right
     * When we close a facility, what data in it do we need to keep.
     * Some files you gotta be careful with ... such as customer orders
use
       line #s to navigate ... you can't just get rid of lines that are
dead,
       and be able to access rest of the order.
     * As i developed the KILLIT software, I started with files that
either
       were most bulky in disk consumption, or were giving humans
conniptions
       of the run-out-of-#s kind
   You might also look at software duplicated when new releases BMRs
etc.
   come in ... for example, how many execution & source members do you
have
   of ORD500 & how big are they?  Can you identify oldest & is it Ok to
kill
   oldest, only keeping most current versions?

   Letting this topic get to 90% is in my opinion a very serious
disaster for
   your company computer system.  During a BPCS conversion we went over
100%
   & we had data lost & corrupted.  I have seen IBM guidance saying.
     * At 90% it is time to shut the computer system down entirely
awaiting a
       hardware solution.
     * At 80% you order whatever fix ... software solution and/or
hardware
       solution & get it installed before you hit 90%
     * At 70% you figure out what you gonna do & get it implemented so
you
       not get to 80% ... we currently struggling at just over 70%
because
       the work load on me means I not have as much time for this as
Iought
       to spend on it, and I have not been able to convince higher
       authorities of certain solutions I think we need.

    
    Hi,

    We r using BPCS 6.04 on AS400.
    Server Hard Disk is filled upto 90%.
    I want to purge data for specific period. (i.e. from 01-04-1999 to
31-
   03-2003.

    can anyone tell me how to purge this data.

    Vitthal Kulkarni.
    Sys Admin
    Matsushita Washing Machine I pvt Ltd.
    India.

   --
   This is the SSA's BPCS ERP System (BPCS-L) mailing list
   To post a message email: BPCS-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
   or email: BPCS-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/bpcs-l.

   Delivered-To: macwheel99@xxxxxxxxxxx
--
This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a
message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.

Delivered-To: tmolyneux@xxxxxxxxxxxxxx

--
This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a
message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.

Delivered-To: sean.mcgovern@xxxxxxxxxxxxxxxxxxxxxxx