Re: Data Purging -- BPCS-L

   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