Re: Clean Up

["David Shea" <dshea@xxxxxxxxxxxx>]

When you find the list of files that can be cleaned out regularly, you might
want to take a look at ARCTOOLS (http://www.arctools.com) to assist you in
doing a regular clean-up.  ARCTOOLS allows you to very easily create
selective (field based record selection tests - like Query) purge (or
archive) jobs that can be run without locking out the users.  Also - if you
have an existing purge-only routine but you want to archive the data instead
of throwing it away, it can add archiving to any existing purge routine
without programming.  You just run a setup routine, run your existing purge,
then run the archive step afterwards.

So, if you find that there are ten files that you want to clean out every
week, and five more that you want to clean out monthly, you could set up
some jobs (either CL programs or perhaps scheduled jobs) that would run on a
regular basis to clean up the files.

You can also use it to clean out all the 'soft delete' records throughout
BPCS.  These could be archived to another library, thus speeding up the
production system while keeping the records available on disk.  If you want
to get fancy, you can add the archive PF into logical files to re-include
them in selected reports and inquiries.  This makes the data available in
those few places where you'll need to see all that old data, but the rest of
the system will go much faster.

Good luck.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Purge and Archive your AS/400 Data Without Programming with ARCTOOLS (tm)
DCSoftware, Inc.
(508) 435-8243
(508) 435-4498 (fax)
http://www.arctools.com
mailto:info@arctools.com
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-----Original Message-----
From: SANDEEP GOYAL <SGOYAL@everestjennings.com>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: Tuesday, November 23, 1999 7:41 AM
Subject: Clean Up


>Hi everybody,
> I was just looking to clean the system. I noticed file ZQL had more than 2
million rcds and was more than 1 GB in size. What is the use of this file ?
Can we clear it on a regular basis.
>  Does anybody have a list of files that can be cleaned on a regular
basis - say weekly ?
>  We are on BPCS 6.04 Mixed Mode.
>
>Sandeep Goyal
>
>+---
>| 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
+---