ACR900 - too long // purging not a good idea

["Dean Olson" <dolson@xxxxxxxxxx>]

Dear Otto,

It's always a sad day when a user or an auditor goes looking
for old data only to find out that it was purged instead of
archived (especially if it's a SOX auditor). Seasoned IS
guys understand that so they are very careful to save a
generous amount of old data when they set SYS800 purge
parameters. Consequently, the purge process typically
won't yield dramatic processing time reductions.

The better idea is archiving and with Locksmith (tm) you can
get the response time improvement you are looking for
without destroying the data.

The archived records retain all the intricate links between
BPCS files. That enables a user or an auditor to look at those
records again as if they had never been removed from your
production library .... and .... that means that you can remove
even last year's closed transactions from your production
library. Now we're talking about dramatic processing
time reductions.

DeeDee Virgei wisely recommended a Reorganize Physical
File Member step; Locksmith does that automatically.

Here's a link.
    http://www.unbeatenpathintl.com/locksmith_bpcs.htm

A free demo is available. Locksmith is one of our
Bells & WhistlesR for BPCS products:
    http://www.unbeatenpathintl.com/bells/source/1.html

Warm regards and peace to you,

Dean Olson
Director of Software Technology
Unbeaten Path International



Europe:  44 17 37 78977
North America: (888) 874-8008
Latin  America: (262) 681-3151   [ se habla Espanol ]


www.upisox.com



+++++++  +++++++  +++++++  +++++++  +++++++  +++++++
Has anyone changed the purge parameter in SYS800 for closed A/R?
Changing this number will increase/decrease the time for ACR900 to
execute.
      Dan Sweeney
      Senior Technical Consultant
      PHOENIX Business Consulting, Inc.
      Tel: 724.836.4446 x7, Cell:  860.490.6712,
      E-Fax: 832-550-5144
      www.phoenixbcinc.com
      SSA GLOBAL Recognized Services Provider




+++++++  +++++++  +++++++  +++++++  +++++++  +++++++
I'd try running a RGZPFM (Reorganize Physical File Mbr) on the RAR and
possibly RTX one evening or weekend when users are not using BPCS (or at
least not using ACR programs).
      Regards,
      DeeDee Virgei
      Project Leader
      Nelson Stud Welding, Inc



+++++++  +++++++  +++++++  +++++++  +++++++  +++++++
From: Otto Hason
Sent: Wednesday, March 15, 2006 2:44 AM
To: SSA's BPCS ERP System
Subject: [BPCS-L] ACR900 - too long

Hi all,
BPCS v 6.0.04
we are unlucky with ACR900 - month end close. Before 3 years it took
1700 s CPU time, now it consumes about 8000 s.
Have you any tip how to improve it?

We don't use fields like corporate parent, promotion cust.nr., sales
organization parent and so on in RCM - they are filled with RCM.CCUST. I
think ACR900 spends much time with working with these "superior"
customer levels.  Is there a way here?
I don't think we have much more data there, but time keeps on rising.
Thanks for your advice
         oTTo